Power BI - Filters
Modified on: Tue, Aug 27 2019 10:22 AMWhat 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)
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.
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:
- Using the Filters pane: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-report-filter (5 minutes to read)
- Filters in Detail : https://docs.microsoft.com/en-us/power-bi/power-bi-reports-filters-and-highlighting (4 minutes to read)
- Bookmarks: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-bookmarks (7 minutes to read)