Sale 20% of all courses - Book Today

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 visualization with just a click. Selecting a visualization 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 24381 Reviews
Very knowledgeable Trainer - Good overview and answers all questions -Project Beginner Perth
Shannon - Project Beginner, .
Interactive and productive. -Project Beginner Perth
Marte - Project Beginner, .
Good way of getting started! -Project Beginner Perth
Ben - Project Beginner, .
Great instructions and easy to follow considering training is online - would be good to have speakers in the room so I could hear the other participants. -Office365 Intermediate Brisbane
Ade - Office365 Intermediate, .
Microsoft Teams looks is a powerful tool and I am looking forward to using the different apps and learning more about it. -Office365 Intermediate Brisbane
Pam - Office365 Intermediate, .
Great, wonderful - many thanks -Office365 Intermediate Brisbane
Dominic - Office365 Intermediate, .
Michael was very helpful. -Excel Intermediate Sydney
Max - Excel Intermediate, .
John was very clear and friendly. He engaged with the group well through the chat function. I did feel like we spent a lot of time on MS Teams and the group seemed to know how to use some of the capabilities. I felt like this part was too long. Thank you so much John! -Office365 Beginner Melbourne
Tanya - Office365 Beginner, .
Gave some clarity on Power Automate. Made it seem less daunting by using layman's terms. -Office365 Beginner Remote Online
Leon - Office365 Beginner, .
Great training today, having the test environments and resources early was good. John is great presenter, excellent pacing and approachable. -Office365 Beginner Remote Online
Linda - Office365 Beginner, .
Fantastic course. I feel a lot more confident with all the 365! -Office365 Beginner Remote Online
Paula - Office365 Beginner, .
Good session for broad overview, keen to explore more advanced functionality -Office365 Beginner Remote Online
Cameron - Office365 Beginner, .
Great info. Thanks -Office365 Beginner Remote Online
Bass - Office365 Beginner, .
Ken was a great teacher, extremely informative and gave us heaps of information. Thank you very much. -SharePoint Site Owner Melbourne
Roz - SharePoint Site Owner, .
Detailed descriptions, loads of information with clear explanation. -SharePoint Site Owner Melbourne
Natasha - SharePoint Site Owner, .
Very helpful baseline information for sharepoint usage. Will be keen to see how this can be applied at Kubota. -SharePoint Site Owner Melbourne
Lachlan - SharePoint Site Owner, .
Thank you - very informative! -SharePoint Site Owner Melbourne
Louise - SharePoint Site Owner, .
So much to learn in just 2 days! Ken was great, very patient! -SharePoint Site Owner Melbourne
Clare - SharePoint Site Owner, .
Michael was an excellent trainer. I was a bit worried about doing this training online but Michael was very patient. The pace of the course was good and I have learnt a lot of valuable tips which will assist me greatly in my job function. -Excel Intermediate Sydney
Lori - Excel Intermediate, .
great course and have learnt a lot. thanks heaps Jason for sharing your knowledge. -Office365 Beginner Brisbane
Fiona - Office365 Beginner, .

Trusted by Business

Awards and Accreditations

south east asia microsoft training courses nexacu

Follow us