How do I filter my report?
- Corrine Krauss
There are many different ways to filter data in Power BI. This article explains how to use the Filters pane. You can also filter by selecting data points on a report visual to filter the other visuals on the page -- this is referred to as cross-filtering and cross-highlighting and is not explained here.
The Filters pane is also the area where you can view information about the filters and interact with them. The filters pane can have up to 3 sections to show:
- Filters on this visual - filter only affects the single visualization to which it is related
- Filters on this page - filter affects all of the visualizations on the report page
- Filters on all pages - filter affects the entire report
Some of the filters are shaded, and some are not. If a filter is shaded, that means a filter has been applied and some data is being excluded.
In this article:
Display filter details
To understand a filter, expand it and take a look at the available values and counts. To expand the filter, select the arrow next to the filter name.
Change filter selections
Depending on the filter and type of data that Power BI is filtering, options will range from simple selections from a list, to identifying ranges of dates or numbers.
Clear a filter
To reset a filter to (All), clear it by selecting the eraser icon next to the filter name.
To clear all filters at once, use the Reset to default button from the top menu bar.
Related articles