Power BI – Report Level Filters

Filters in Power BI sort data and knowledge based on some selected criteria. That is, you’ll select particular fields or values within fields and view only the information related to them. as an example, you’ve got a dataset related to a store’s sales. Now, using the filters you’ll filter out unnecessary information. you’ll view a report having only the data for the selected aspects.

Report Level Filters

The report-level filters are the filters that you simply use to apply a filter condition on the entire report. The report-level filter will get applied to each visualization and page of a report. Thus, report-level filters are different from visual-level and page-level filters, report-level filters are generalized filters.

Application of report-level filters

Import data from Your Excel to Power BI: Home Tab-> Get Data -> Choose Data which you want Example Excel -> Select the file and Open -> Select The sheet and Load

To use a filter create a visual on the page example: Pie chart

To create a ‘Pie Chart’ drag and drop the data under respective fields

To demonstrate the report level filter we duplicate the pie chart on a new page

Right-click on page 1 -> then select a duplicate page

A duplicate page with the same visuals created

Drag the product field into the filter

Applying basic filtering on visuals

Same filter will be applied automatically to page1

Applying advance filter 

The same Filter automatically applied to the ‘duplicate page’

Lastly, Talking about the report-level filters, they’re the filters that you simply use to use a filter condition on the entire report. Report-level Filters are those that affect all data in this report, regardless of what you are looking at. consider them as global filters.