Power BI Report Level Filters

The Power BI Report level Filters are to filter the visuals (or charts) present on all the pages of a Report. For example, if your report contains 10 pages, then you can use this report level filter to filter those 10 pages at a time. Let me show you how to create Report Level Filters in Power BI with examples.

To create this Report (the combination of pages) for the Power BI Report level Filters demo, we used the SQL Data Source we created in our previous article.

Please refer to the Connect to SQL Server article to understand the Data Source. To demonstrate the Report Level Filters, we will use a chart we created in our earlier posts. This Power BI report has 19 pages: Column Chart, Pie Chart, Treemap, Donut ChartBar Chart, etc.

How to create Power BI Report Level Filters

In this example, we create a Report Level Filter on the Stacked Bar Chart. Remember, this is the 8th page of a total of 19 pages.

As you can see from the screenshot below, we used the Color as the Axis field, Country Name as the Legend field, and Sales amount as the Value field.

Under the Filters section, you can see the list of available report level filters in Power BI. You have to use the Report Level Filters section to create a filter at the report level.

Add Field to Power BI Report Level Filters 2

Let me drag and drop the English Country Region Name from the fields section to the Report level Filters. Expand the English Country Region Name to see the filter types. By default, the Basic Filters option is selected as the Filter type.

For this Power BI Report Level Filter demonstration purpose, we selected Australia, Germany, the United Kingdom, and the United States.

From the screenshot below, you can see that the Stacked Bar chart displays the Sales for the selected countries in a legend.

Power BI Report Level Filters 5

Let me navigate to page 1 of 19. As you can see from the screenshot below, the Pie chart is also filtered by the Report level filter. I mean, it displays the sales for the selected countries.

Report Filters 6

Let me navigate to page 18 of 19. You can see from the screenshot below Power BI Report level filters are filtering these three charts.

Power BI Report Level Filters 7

Use the drop-down to change the report level filtering type to Advanced filtering.

Here, we are applying multiple filters on the Country column. The first filter checks whether the Country contains a united keyword or not. The Second filter checks the countries that do not start with F.

Reportl Filters 8

The report below shows the Bars with Countries that contain the United keyword and those that did not start with F.

Power BI Report Level Filters 9

Let me navigate to page 1 of 19. As you can see, the Pie chart displays the sales for countries that contain the United or do not start with F.

Power BI Report Level Filters 10

Let me remove the existing Power BI report level filters. Next, drag and drop the Sales Amount from the fields section to the report level Filters. Then, expand the Sales Amount to see the filter options. Please refer Filters on Measures article to understand these options.

Power BI Report Level Filters 11

For the demonstration purpose, we selected is greater than as the operator and 1000 as the value. The screenshot below shows that the Stacked Bar chart displays the bars whose sales amount is greater than 1000.

Power BI Report Level Filters 12

Now, you can see that the same filter is applied to the Column chart present on page 2 of 19.

Power BI Report Level Filters 13

The following are the types of other types of Filters with a practical example.

  1. Slicer
  2. Basic Filters
  3. Top N Filters
  4. Filters on Measures
  5. Page-Level Filters
  6. Drill through Filters