In this blog, we will see the difference between Page level and Report level filters in Power BI. If you are new to Power BI and want to learn how to create your first report using it, then please read
this article.
First, let’s understand the hierarchy of the entities used in Power BI.
Report –This comes on top of everything. Whatever you build in one project of Power BI, whatever is saved in one .pbix file is treated as a single report.
Page – In one report, you can create multiple pages as per your need.
Chart – On a single page, you can add single or multiple charts.
If you have understood the topology of entities, then it's easier now to understand what’s the difference between Report level and Page level filter.
- Report Level Filter – It applies the filter to all charts on all the Pages.
- Page Level filter – It applies the filter to all charts on the current Page.
Let's look at the example of each of them.
Page Level Filter Example
I have two charts on one page, I need to filter out some data for both the charts. In the below screen, I want to remove Items with Blank status for both the charts, so I can use Page Level Filter for this.
Drag-drop your column/field under Page Level Filter section >> Apply necessary filtration logic, in my case “Is not blank”.
Click on Apply filter and see the result below
Report level filter example
I have a report with two pages and two charts on each of the pages. I want to apply a filter to all the charts in this report – then, in this case, I will use the Report Level filter. In the below example, I wanted to remove all the items which have the status “Not Stated” from all the charts.
As shown in the below screen >> From P1 Page - Configure your required filter in Report Level Filter section
If you go to P2 >> you will see that Report level filter is applied to charts on this page as well. It doesn’t show items with status Not Started.
That’s it. Hope this will help you in reporting.