All courses available in-class or via remote login

Power BI Video Series

Power BI Filters and Interactions

November 09, 2020

Power BI Video Series | Episode 4

In this video series, Trainer Steven Knight covers key aspects of using Power BI Reports and Dashboards, in eight short & accessible episodes. This video is applicable for both Windows and Mac operating systems, and simply requires the use of an up to date web browser.

This episode covers how to interact with Power BI Reports and Dashboards and an introduction to filters and slicers. 


Interactions
 

Power BI offers interactions with all visualisation with just a click. Selecting a visualisation will take you to the page containing the data relevant to the selected visual. Once on this page, you can select any data point (i.e. employee name) and connected data will be highlighted. Simply click again to clear this selection.

For example:

Click on the name of a salesperson in one graph, the entire page will alter to highlight the data for this salesperson.

 

Filters

Each page in a report is made up of a range of different card, each containing a graph, chart, figure or slicer. When you hover over a card on the page you will see the filter symbol (the funnel), click this symbol to see current filters being applied to that card.

For a broader look at filters head to the collapsible pane on the right-hand side. If you don't see the Filters pane, select the ">" icon from the upper-right corner to expand it. The options available in this pane will vary depending on the settings applied by the document creator. The menu allows for a clear look at all applied filters and all options available. You can set filters at three different levels for the report: visual-level, page-level, and report-level filters. This is a great place for an initial check if your data is showing something unexpected, allowing you check what filters are being applied across the entire document.

Slicers

Slicers are another way of filtering. They narrow the portion of the dataset that is shown in the other report visualizations.

Slicers are a great choice when you want to:

  • Display commonly used or important filters on the report canvas for easier access.
  • Create more focused reports by putting slicers next to important visuals.





If you found Episode 4 of our Power BI Video series helpful be sure to keep an eye out for the next installments coming soon. 

Catch up on past episodes:
Accessing Shared Reports | Power BI Series | Episode 1

Accessing Apps | Power BI Series | Episode 2

How to Navigate Power BI | Power BI Video Series | Episode 3


To learn more about Power BI and our range of training options. View Power BI Courses

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 24229 Reviews
Thank you very much for your detailed instruction Domenic! I really enjoyed your course very much. The course was really useful and I can recommend your course to everyone! -Analysis & Dashboards Perth
Saori - Analysis & Dashboards, .
Good and professional training session! thanks to Domenic for carrying out the course. -Analysis & Dashboards Perth
Ayat - Analysis & Dashboards, .
A lot of information covered however course was at a good pace with sufficent breaks. Jason was clear and easy to understand with the way he presented the information. Attending remotely it at times was hard to hear the questions from the people in the room so sometimes a bit confusing I found it really informative and would recommend to collegues and friends Thank you -Power BI Beginner Brisbane
Christine - Power BI Beginner, .
Course was great, and very informative. -Power BI Beginner Brisbane
Mark - Power BI Beginner, .
THe beginner Power BI course run by Jason was fantastic. I really feel like I have had a clear & thourough introduction to the application. -Power BI Beginner Brisbane
Anna - Power BI Beginner, .
Jason was great. Very clear in instructions and went at a good speed for someone with minimal exposure to Power BI. It was a long day of learning but covered a lot of ground -Power BI Beginner Brisbane
Melissa - Power BI Beginner, .
Good training - easy to follow -Power BI Beginner Brisbane
Rachael - Power BI Beginner, .
Excellent !!! -Power BI Beginner Brisbane
Khurram - Power BI Beginner, .
Good interactive and practical course presented well by Jason. -Power BI Beginner Brisbane
Anthony - Power BI Beginner, .
It was very helpful and informative. Steven was very patient and knowledgeable. -Excel Beginner Brisbane
Jessica - Excel Beginner, .
Steve delivered a very interesting and informative session that will support me in my position moving forward -Excel Beginner Brisbane
Margaret - Excel Beginner, .
Great course. I learnt a lot. Steven was a great trainer. -Excel Beginner Brisbane
Alison - Excel Beginner, .
Very practical and informative session. Will be very useful in my daily work. -Excel Beginner Brisbane
Julie - Excel Beginner, .
very patient, relatable presenter. Good examples -Excel Beginner Brisbane
Kate - Excel Beginner, .
Thank you. -Power BI Beginner Adelaide
Shane - Power BI Beginner, .
Excellent fundamental class for R by Tamara -R Basics Perth
Virendra - R Basics, .
It was good but I think I will need to do the Basic Course as some of the techniques were a little beyond me. Thanks Stuart for your patience. -Word Intermediate Brisbane
Carmen - Word Intermediate, .
Thank you Stuart -Word Intermediate Brisbane
Chiho - Word Intermediate, .
Learnt some good techniques. Thanks Stuart -Word Intermediate Brisbane
Millie - Word Intermediate, .
Good course. It was good to uncover details about styles. -Word Intermediate Brisbane
Graham - Word Intermediate, .

Trusted by Business

Procured by Government

Awards and Accreditations

Map of Australia

Follow us