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:

Discover more about User-created reports

For a hands-on learning experience, explore our Deep dive courses in The Academy, and watch as Gary builds reports from scratch to meet specific briefs. 

If you prefer to start at the beginning, check out Get Started: Reporting and Analytics with Power BI. You'll begin with Power BI’s top five features, then dive deeper into each one with step-by-step guidance.

Need quick answers? Check out our FAQ, Reporting and Analytics with Power BI, packed with 100+ common questions and in-depth resources. You can also join our regular Ask Me Anything: Reporting live events, to ask your question directly to a Power BI expert. Search PWRFAQ in The Academy for real-world use cases, examples, and scenarios with User-created reports.

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