How to Apply Filter on All Pages in Power BI
Power BI allows you to apply filters to all pages through the use of a report-level filter or a page-level filter that is synchronized across all pages. Here’s how you can do it:
Report-Level Filter:
A report-level filter applies the same filter condition to all the pages within a Power BI report. This means that any visuals on different pages will be filtered based on the selected filter values.
1. Open your Power BI report.
2. Go to the "Home" tab on the Power BI ribbon.
3. Click on the "Edit Report" button.
4. In the "Fields" pane on the right side, select the column you want to apply a filter to.
5. Drag and drop the selected column to the "Report level filters" area at the top of the "Fields" pane.
6. Define the filter condition by selecting the desired values or providing an expression.
7. Click on the "Apply filter" button to apply the filter to all the pages in the report.
By setting a report-level filter, you can ensure that the selected filter values are applied consistently across all pages in your Power BI report.
Example:
Let’s say you have a Power BI report with two pages: “Sales Overview” and “Product Performance.” You want to apply a filter on the “Product Category” column to show only the data related to the “Electronics” category on both pages.
1. Open your Power BI report.
2. Go to the "Home" tab on the Power BI ribbon.
3. Click on the "Edit Report" button.
4. In the "Fields" pane on the right side, find the "Product Category" column.
5. Drag and drop the "Product Category" column to the "Report level filters" area.
6. In the filter dialog that appears, select the "Electronics" category.
7. Click on the "Apply filter" button to apply the filter.
8. Switch to the "Sales Overview" page and verify that only sales data related to the "Electronics" category is displayed.
9. Switch to the "Product Performance" page and verify that only performance data related to the "Electronics" category is displayed.
With the report-level filter applied, any changes you make to the filter condition will be reflected on all pages in the report.
Page-Level Filter Synchronized Across Pages:
If you want to apply a filter to specific visuals across all pages, you can use a page-level filter that is synchronized across the pages.
1. Open your Power BI report.
2. Go to the page where you want to apply the filter.
3. Select the visual or visuals you want to filter.
4. In the "Visualizations" pane on the right side, go to the "Filters" section.
5. Click on the "+" button to add a new filter.
6. In the filter dialog that appears, select the desired column and define the filter condition.
7. Click on the "Apply filter" button to apply the filter to the selected visuals.
8. Switch to other pages in the report and verify that the same filter is applied to the synchronized visuals.
By using a page-level filter synchronized across pages, you can ensure that specific visuals have consistent filtering across the entire report.
Example:
Let’s continue with the previous example of the Power BI report with two pages: “Sales Overview” and “Product Performance.” You want to apply a filter on the “Product Category” column only to the “Sales Overview” page.
1. Open your Power BI report.
2. Go to the "Sales Overview" page.
3. Select the visual or visuals that you want to filter, such as a bar chart or table.
4. In the "Visualizations" pane on the right side, go to the "Filters" section.
5. Click on the "+" button to add a new filter.
6. In the filter dialog that appears, select the "Product Category" column.
7. Define the filter condition, such as selecting the "Electronics" category.
8. Click on the "Apply filter" button to apply the filter to the selected visuals.
9. Switch to the "Product Performance" page and verify that the filter is not applied to the visuals on this page.
With the page-level filter applied and synchronized across pages, the visuals on the “Sales Overview” page will show data only for the “Electronics” category, while the visuals on the “Product Performance” page will remain unfiltered.