Reporting - 3 ways to filter report data

In this article, we'll take a look at the basics of filtering, Filters remove all but the data you want to focus on, and can be applied:

• across all pages
• to a specific page
• to a specific data visual

Apply a filter to all pages

This is a very common use for filters. Click and drag to add multiple Data fields to 'FIlters on all pages' The data item used to filter the report does not have to be displayed in the visual:

Apply a filter to a specific page only

Click and drag to add multiple Data fields to 'FIlters on this page' The data item used to filter the report does not have to be displayed in the visual:

Apply a filter to a specific visualisation only

Click to select a visual - when the corner markers appear, a filter selection will apply to this visual only:

Find out more about reporting and analytics with Microsoft Power BI

Join us live for Key techniques for using Power BI fixed reports in The Academy. We'll start with a tour of the Power BI reporting area, then, we’ll open up the Learning Progress report and using real-life examples, we’ll dive into the detail.

If you're using Reporting and Analytics already and have a question, come along to our 'Ask me Anything' events in the Academy to ask questions and share feedback directly with the team.

Join us for our update and roadmap live event to see the latest feature releases and roadmap for the next quarter and share feedback directly with the team. 

Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.