How to create Page Level Filters in Power BI with an example? The 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 filter those four reports at a time.
To demonstrate the Page Level Filters, we are going to use the Column, Pie plot, and Bar Graph that we created in our earlier post. Please refer to the Power BI page for more info.
Create Power BI Page Level Filters
Under the below Filters section, you can see the list of available page level filters. You have to use the Page Level Filters section to create the one you need.
Let me drag and drop the English Country Region Name from the fields section to the Power BI Page level Filters. Expand the English Country Region Name to see the available types. By default, the BasicFilters option is 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 displays the selected countries. , Bar chart displays 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. Don’t forget to hit the Apply Filter at the bottom.
The below page shows the Countries that contain the United keyword, and the countries that do not start with F.
Let me remove the existing one, and drag and drop the Product Color from the fields section to the Power BI 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 displays the sales amount for the selected product colors, and the Bar chart displays the sales amount for selected colors.
Let me remove the existing one, and drag and drop the Sales Amount from the Fields section to the Page level Filters. Next, expand the Sales Amount to see the options. Please refer to the 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 as the value. All the reports on the below page display the countries or states whose Sales Amount is greater than 3000.
