Page-level filters in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Page-Level Filters in Power BI

Which statement best describes the behavior of page-level filters in a Power BI report?

A Page-level filters apply only to the visuals on the current report page.

B Page-level filters apply to all pages in the report.

C Page-level filters apply only to a single visual on the page.

D Page-level filters override report-level filters on all pages.

💡 Hint

Think about the scope of filters and how they affect visuals grouped by pages.

Page-level filters affect all visuals on the current page only. They do not impact other pages or individual visuals separately.

🎯 Scenario

intermediate

Applying Page-Level Filters for Regional Sales

You have a report with multiple pages showing sales data for different regions. You want to filter the 'West' region sales only on the 'West Region' page without affecting other pages. Which filter type should you use?

A Page-level filter for 'West' region on the 'West Region' page

B Report-level filter for 'West' region

C Visual-level filter for 'West' region on all visuals

D No filter; use slicers instead

💡 Hint

Consider the filter scope that limits filtering to one page only.

Page-level filters apply only to the current page, so filtering 'West' region on the 'West Region' page will not affect other pages.

❓ dax_lod_result

advanced

DAX Measure with Page-Level Filter Impact

Given a page-level filter on 'Year' = 2023, what is the result of the following DAX measure on that page?

Sales 2023 = CALCULATE(SUM(Sales[Amount]), ALL(Sales[Year]))

Power BI

Sales 2023 = CALCULATE(SUM(Sales[Amount]), ALL(Sales[Year]))

A Zero because ALL removes all filters including page-level

B Sum of Sales Amount only for Year 2023 due to page filter

C Sum of Sales Amount for all years ignoring the page filter

D Sum of Sales Amount for the current filter context including page filter

💡 Hint

Recall what the ALL function does to filters in DAX.

The ALL function removes filters on the 'Year' column, so the measure sums sales for all years ignoring the page-level filter on 'Year'.

❓ visualization

advanced

Designing a Report Page with Page-Level Filters

You want to create a report page that shows sales data filtered by 'Product Category' using a page-level filter. Which of the following design choices best follows Power BI best practices?

A Add a slicer for 'Product Category' on the page and also apply the same filter in the page-level Filters pane.

B Apply the 'Product Category' filter in the Filters pane at the page level and do not add slicers for it on the page.

C Apply the 'Product Category' filter only as a visual-level filter on each visual.

D Use report-level filter for 'Product Category' and add slicers on the page.

💡 Hint

Think about filter redundancy and user experience.

Applying the filter at the page level in the Filters pane ensures all visuals are filtered consistently without redundant slicers, improving clarity and performance.

🔧 Formula Fix

expert

Troubleshooting Unexpected Filter Behavior

You applied a page-level filter on 'Region' = 'East' but notice that some visuals on the page still show data from other regions. What is the most likely cause?

A The report-level filter is set to include all regions, overriding page-level filters.

B The page-level filter is not saved properly and is inactive.

C The data model has inactive relationships causing filter issues.

D Some visuals have visual-level filters that override the page-level filter.

💡 Hint

Consider filter precedence and overrides in Power BI.

Visual-level filters have higher precedence and can override page-level filters, causing some visuals to show data outside the page filter.