Power BI - Filters
What Are Filters
You can use filters to remove all but the data you want to
focus on. When a filter is applied, that data will not be included in the
report.
Use the "Filters" Pane on the right of your report.
If it is not displayed, you may need to click to expand it out. An expanded
Filters pane will look like this:
Filters apply to
-
Report:
applied to all pages & visuals in the report
-
Page:
applies to all the visuals on the current report page
-
Visual:
applies to a single visual on a report page. You only see visual level filters
if you've selected a visual on the report canvas.
The Filters pane
contains filters that the report designer added to the report. Consumers like
you can interact with the existing filters and save your changes, but you can't
add new filters to the report.
In the example below, you can see the report has
- 1 Report filter
- 6 Page filters
- 6 Visual filters (for the selected scatter plot)
s
View only those filters applied to a visual
To get a closer look at the filters applied to a specific visual, hover over the visual to reveal the filter icon Screenshot of the Filter icon.. Select that filter icon to see a pop-up with all the filters, slicers, and so on, affecting that visual. The filters on the pop-up are the same filters displayed on the Filters pane.
Search a Filter
Sometimes a filter can have a long list of values. Use the search box to find and select the value you want.
Tip: To select more than one filter value at a time, hold down the CTRL key. Most filters support multi-select.
Remembering / Resetting Filters
The first time you load a report in Power BI, you will see a
report with the default filters applied. This is whatever the report designer
set them to.
When you exit the report, your filters are saved so the next
time you load the report it will have the same filters from last time. To undo
your filtering and return to the default filtering, slicing, drill, and sorting
set by the report author, select Reset
to default from the top menubar.
If there are changes you'd like to save, you can also create
a personal bookmark. For more information, see What are bookmarks?.
More Information
Microsoft maintains the references below if you would like
more details: