How to Use Page Level Filter in Power BI: Step-by-Step Guide
In Power BI, a
page level filter lets you filter data for only one report page. You add it by selecting the page, then dragging fields into the Filters on this page pane and setting filter conditions. This controls what data visuals on that page display without affecting other pages.Syntax
Page level filters are applied through the Power BI interface, not by code. The key parts are:
- Filters pane: The area where you add filters.
- Filters on this page: Section for page level filters.
- Field: The data column you want to filter.
- Filter condition: The rule that decides which data to show.
You drag a field into the Filters on this page area and then set the filter condition to control data on that page only.
power_bi
/* No code syntax as filters are set via UI in Power BI Desktop */Example
This example shows how to filter a sales report page to only show data for the year 2023.
plaintext
1. Open your Power BI report and select the page you want to filter. 2. On the right side, find the Filters pane. 3. Under 'Filters on this page', drag the 'Year' field from your data fields. 4. Click the filter dropdown and select '2023' only. 5. The visuals on this page now show data only for 2023.
Output
The report page visuals update to display only sales data from the year 2023.
Common Pitfalls
- Applying filters to the wrong level: Using page level filters when you want to filter all pages (use report level filters instead).
- Not noticing filter pane sections: Filters on this page only affect the current page, not others.
- Overlapping filters: If you have conflicting filters at page and visual level, the visual level filter overrides.
- Forgetting to clear filters: Filters stay active until removed, which can confuse users.
plaintext
/* Wrong: Dragging a field to 'Filters on this visual' when you want to filter the whole page.
Correct: Drag the field to 'Filters on this page' to affect all visuals on the page. */Quick Reference
| Filter Level | Scope | Effect |
|---|---|---|
| Visual Level Filter | Single visual | Filters only one visual on the page |
| Page Level Filter | Single page | Filters all visuals on the selected page |
| Report Level Filter | Entire report | Filters all pages and visuals in the report |
Key Takeaways
Page level filters control data shown only on the selected report page.
Add page level filters by dragging fields into the 'Filters on this page' pane.
Page level filters do not affect other report pages or visuals outside the page.
Visual level filters override page level filters for that specific visual.
Always check filter levels to avoid unexpected data filtering.