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

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Report-Level Filters

In Power BI, what is the main effect of applying a report-level filter?

A It creates a new table with filtered data.

B It filters data on all pages of the report.

C It filters data only on the selected visual.

D It filters data only on the current page.

💡 Hint

Think about how report-level filters affect multiple pages.

Report-level filters apply to all pages in the report, affecting all visuals unless overridden.

❓ dax_lod_result

intermediate

DAX Measure with Report-Level Filter Context

Given a report-level filter on 'Region' = 'West', what will the following DAX measure return?

Sales West = CALCULATE(SUM(Sales[Amount]), ALL(Sales[Region]))

A Total sales ignoring the report-level filter on Region.

B Total sales only for the 'West' region.

C Total sales for all regions except 'West'.

D Zero, because ALL removes all filters including report-level.

💡 Hint

Recall how the ALL function works with filters.

The ALL function removes filters on the specified column, ignoring the report-level filter on Region, so the measure returns total sales for all regions.

❓ visualization

advanced

Choosing the Best Visual for Report-Level Filter Impact

You want to show how a report-level filter on 'Year' affects sales across different product categories on all report pages. Which visual best communicates this impact clearly?

A A line chart showing sales over time without filtering by Year.

B A pie chart showing sales by product category without any filters.

C A table listing sales by product category with no filter applied.

D A bar chart showing sales by product category with a slicer for Year on the report level.

💡 Hint

Think about how to show filtered data clearly and interactively.

A bar chart with a report-level Year slicer clearly shows sales by category filtered by the selected year across all pages.

🔧 Formula Fix

advanced

Debugging Unexpected Filter Behavior

You applied a report-level filter on 'Country' = 'USA', but a visual on a page shows data from all countries. What is the most likely cause?

A The data model does not include the Country column.

B The report-level filter is not saved properly.

C The visual has a visual-level filter overriding the report-level filter.

D The report-level filter only applies to the first page.

💡 Hint

Consider filter priority in Power BI.

Visual-level filters override report-level filters, so if a visual has no filter or a conflicting filter, it can show unfiltered data.

🎯 Scenario

expert

Designing Report-Level Filters for Multiple User Roles

You have a report used by sales managers in different regions. You want each manager to see only their region's data by default, but allow them to change the filter if needed. How should you implement this using report-level filters?

A Use dynamic security with USERNAME() and apply region filter dynamically at report level.

B Set a fixed report-level filter for one region and ask managers to change it manually.

C Apply page-level filters for each region and duplicate pages for each manager.

D Use visual-level filters on each visual to restrict data by region.

💡 Hint

Think about how to personalize filters dynamically for users.

Dynamic security with USERNAME() allows applying report-level filters based on the logged-in user, enabling default filtering per region with flexibility.