Power BI Page level Filters are used to filter the charts (or visuals) present in 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. In this article we will show you, How to create Page Level Filters in Power BI with example.
How to create Power BI Page Level Filters
To demonstrate the Page Level Filters in Power BI, we are going to use the Column Chart, Pie Chart, and Bar Charts that we created in our earlier post.
Under the Filters section, you can see the list of available filters in Power BI. You have to use the Page Level Filters section to create a filter at page level.
Let me drag and drop the English Country Region Name from fields section to the Page level Filters.
Expand the English Country Region Name to see the filter types. By default, Basic Filters option is selected as the Filter type
For the demo purpose, let me select Australia, Germany, United Kingdom, and United States. From the below screenshot you can see that, the Column chart is displaying the Sales for the selected countries, Pie chart is displaying 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 filtering.
Here, we are applying multiple filters on Country column. First will check whether the Country contains united keyword or not. Or, Second will check the countries does not start with F.
Below page is showing the Countries that contains United keyword, and the countries that does not start with F.
Let me remove the existing page level filters, 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 Filtering fields.
From the below screenshot you can see that, the Column chart is displaying the Sales Amount for the selected colors, Pie chart is displaying sales amount for the selected product colors, and Bar chart is displaying the sales amount for selected colors.
Let me remove the existing page level filters, and drag and drop the Sales Amount from fields section to the Page level Filters. Next, expand the Sales Amount to see the filter options. Please refer Filters on Measures article to understand these options
For the demonstration purpose we selected is greater than as the operator, and 3000 the value. All the reports in the below page are displaying the countries, or states whose Sales Amount is greater than 3000.
