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

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Visual-Level Filters in Power BI

Which statement best describes the effect of applying a visual-level filter in Power BI?

A It filters data only for the selected visual without affecting other visuals on the report page.

B It filters data for all visuals on the report page but not on other pages.

C It filters data for the entire report across all pages and visuals.

D It permanently removes filtered data from the dataset.

💡 Hint

Think about how filters affect visuals individually versus globally.

Visual-level filters apply only to the specific visual they are set on, leaving other visuals unaffected.

❓ dax_lod_result

intermediate

DAX Measure with Visual-Level Filter Impact

Given a measure Total Sales = SUM(Sales[Amount]) and a visual-level filter on Sales[Region] set to "West", what will Total Sales show in that visual?

Power BI

Total Sales = SUM(Sales[Amount])

A Sum of sales amounts for all regions but only for the current year.

B Sum of sales amounts for all regions ignoring the filter.

C Sum of sales amounts only for the West region.

D Sum of sales amounts excluding the West region.

💡 Hint

Visual-level filters limit the data context for the measure in that visual.

The visual-level filter restricts data to the West region, so the measure sums only those sales.

❓ visualization

advanced

Choosing the Correct Visual-Level Filter Setup

You want to show a bar chart of monthly sales but only for products in the "Electronics" category. Which visual-level filter setup is correct?

A Apply a visual-level filter on <code>Product[Category]</code> set to "Electronics" on the bar chart visual.

B Apply a page-level filter on <code>Product[Category]</code> set to "Electronics" on the report page.

C Apply a report-level filter on <code>Product[Category]</code> set to "Electronics" on the entire report.

D Create a calculated column filtering only Electronics products and use it in the visual.

💡 Hint

Focus on filtering only the specific visual, not the whole page or report.

Visual-level filters apply only to the selected visual, so applying the filter on the bar chart is correct.

🔧 Formula Fix

advanced

Troubleshooting Visual-Level Filter Not Working

You applied a visual-level filter on Customer[Country] to show only "USA" customers in a table visual, but the table still shows all countries. What is the most likely cause?

A The visual-level filter is overridden by a page-level filter including all countries.

B The data model has no relationship between Customer and the table's fact data.

C The filter is applied on a slicer, not on the visual-level filter pane.

D The <code>Customer[Country]</code> field is not included in the visual's data fields.

💡 Hint

Consider how relationships affect filtering in visuals.

If there is no relationship between Customer and the fact data, filtering on Customer[Country] won't affect the visual's data.

🎯 Scenario

expert

Combining Visual-Level Filters with DAX Measures

You have a measure High Sales Count = CALCULATE(COUNTROWS(Sales), Sales[Amount] > 1000). You apply a visual-level filter on Sales[Year] = 2023. What does High Sales Count show in the visual?

A Count of all sales rows regardless of year or amount.

B Count of sales rows with amount &gt; 1000 for all years ignoring the filter.

C Count of sales rows for year 2023 ignoring the amount filter.

D Count of sales rows with amount &gt; 1000 only for year 2023.

💡 Hint

Visual-level filters affect the filter context of measures unless overridden inside the measure.

The visual-level filter restricts data to year 2023, so the measure counts only sales over 1000 in 2023.