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.
...
- 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:
Anchor displayfilter displayfilter
Display filter details
| displayfilter | |
| displayfilter |
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.
Anchor changefilter changefilter
Change filter selections
| changefilter | |
| changefilter |
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.
Anchor clearfilter clearfilter
Clear a filter
| clearfilter | |
| clearfilter |
To reset a filter to (All), clear it by selecting the eraser icon next to the filter name.
| Info |
|---|
To clear all filters at once, use the Reset to default button from the top menu bar.
|
...