How to create Page Level Filters in Power BI with an example?. The Power BI Page level Filters are useful to refine the charts (or visuals) present on the page. For example, if your page contains four charts, then you can use this page level filter to filters those four reports at a time.
How to create Power BI Page Level Filters
To demonstrate the Page Level Filters in Power BI, we are going to use the Column, Pie plot, and Bar Graph that we created in our earlier Power BI post.
Under the below section, you can see the list of available page level filters in Power BI. You have to use the Page Level Filters section to create the one you needed.
Let me drag and drop the English Country Region Name from the fields section to the Page level Filters.
Expand the English Country Region Name to see the available types. By default, the BasicFilters option selected as the Filter type.
For the demo purpose, let me select Australia, Germany, the United Kingdom, and the United States. From the screenshot below, you can see that the Column chart is displaying Sales for the selected countries. The pie chart is displaying the selected countries. And, Bar chart is displaying the States that belong to these countries.
Use the drop-down to change the filtering type to Advanced.
Here, we are applying multiple filters on the CountryName column. The first one checks whether the Country contains a united keyword or not. Or, the Second condition checks the countries that do not start with F.
The below page is showing the Countries that contain the United keyword, and the countries do not start with F.
Let me remove the existing one, and drag and drop the Product Color from fields section to the Page level Filters.
Please select Blue, Red, Silver, and Yellow colors as the basic fields.
From the screenshot below, you can see that the Column chart is displaying the Sales Amount for the selected colors. The Pie chart is displaying the sales amount for the selected product colors, and Bar chart is displaying the sales amount for selected colors.
Let me remove the existing one, and drag and drop the Sales Amount from Fields section to the Page level Filters. Next, expand the Sales Amount to see the options. Please refer to Filterson Measures article to understand these options.
For this Power BI Page Level Filters demonstration purpose, we selected is greater than as the operator, and 3000 the value. All the reports on the below page are displaying the countries or states whose Sales Amount is greater than 3000.
The following are the types of other types of Filters with a practical example.
