Report-level filters in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a report-level filter in Power BI?

A report-level filter applies to all pages in a Power BI report, filtering data across the entire report.

beginner

How does a report-level filter differ from a page-level filter?

A report-level filter affects all pages in the report, while a page-level filter only affects the current page.

intermediate

Can report-level filters be overridden by visual-level filters?

No, report-level filters apply first and affect all data. Visual-level filters further refine data within visuals but cannot override report-level filters.

beginner

Where do you set report-level filters in Power BI Desktop?

In Power BI Desktop, report-level filters are set in the Filters pane under the 'Filters on all pages' section.

beginner

Why use report-level filters instead of page-level filters?

Report-level filters save time by applying the same filter across all pages, ensuring consistent data views throughout the report.

What does a report-level filter affect in Power BI?

A Only the current page

B All pages in the report

C Only one visual

D Only the data source

Report-level filters apply to all pages in the report, filtering data globally.

Where can you find report-level filters in Power BI Desktop?

A Data view

B Visualizations pane

C Filters pane under 'Filters on all pages'

D Model view

Report-level filters are located in the Filters pane under the section 'Filters on all pages'.

Which filter type has the highest priority in Power BI?

A Visual-level filter

B Page-level filter

C Data source filter

D Report-level filter

Visual-level filters have the highest priority and refine data after report and page-level filters.

If you want to filter data across all report pages, which filter should you use?

A Report-level filter

B Page-level filter

C Visual-level filter

D No filter

Report-level filters apply the filter to all pages, making them ideal for global filtering.

Can report-level filters be different on each page?

A Yes, they can be different per page

B Only in Power BI Service

C Only if you duplicate the report

D No, they apply to all pages equally

Report-level filters apply the same filter across all pages; they cannot be different per page.

Explain what a report-level filter is and how it affects a Power BI report.

Think about how one filter can control data on every page.

Describe the difference between report-level, page-level, and visual-level filters in Power BI.

Consider which filters affect all pages, one page, or just one visual.