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.

Practice

1. What is the main purpose of a Visual-level filter in Power BI?

easy

A. To limit data shown only in one specific visual on the report page.

B. To filter data across all visuals on all report pages.

C. To change the data model structure permanently.

D. To create new calculated columns in the dataset.

Solution

1. Step 1: Understand the scope of Visual-level filters

   Visual-level filters apply only to the visual they are set on, not affecting other visuals or pages.

2. Step 2: Compare with other filter types

   Page-level filters affect all visuals on a page, and report-level filters affect all pages. Visual-level filters are more specific.

3. Final Answer:

   To limit data shown only in one specific visual on the report page. -> Option A

4. Quick Check:

   Visual-level filter = single visual data limit [OK]

Hint: Visual-level filters affect only one visual, not the whole report. [OK]

Common Mistakes:

• Confusing visual-level filters with page-level filters
• Thinking visual-level filters change the data model
• Assuming visual-level filters apply to all report pages

2. Which of the following is the correct way to apply a visual-level filter in Power BI?

easy

A. Drag a field to the Visual-level filters pane and select filter values.

B. Write a DAX formula in the data model to filter the visual.

C. Apply a filter in the Query Editor before loading data.

D. Use the slicer visual to filter all visuals on the page.

Solution

1. Step 1: Identify how to apply visual-level filters

   Visual-level filters are applied by dragging fields into the Visual-level filters pane and choosing filter criteria.

2. Step 2: Differentiate from other filtering methods

   DAX formulas and Query Editor filters affect data model or data load, not just one visual. Slicers filter multiple visuals, not just one.

3. Final Answer:

   Drag a field to the Visual-level filters pane and select filter values. -> Option A

4. Quick Check:

   Drag field to Visual-level filters pane = correct method [OK]

Hint: Drag fields to Visual-level filters pane to filter one visual. [OK]

Common Mistakes:

• Trying to filter visuals using DAX instead of filter pane
• Confusing slicers with visual-level filters
• Applying filters in Query Editor expecting visual-only effect

3. Given a bar chart visual showing sales by region, if you apply a visual-level filter to include only 'East' and 'West' regions, what will the visual display?

medium

A. Sales data for all regions except 'East' and 'West'.

B. An error because multiple regions cannot be filtered visually.

C. Sales data for all regions without any filter.

D. Sales data only for 'East' and 'West' regions.

Solution

1. Step 1: Understand the effect of visual-level filters on data

   Applying a visual-level filter to include only 'East' and 'West' means the visual will show data only for these two regions.

2. Step 2: Confirm no error occurs with multiple selections

   Power BI allows multiple values in visual-level filters, so no error will occur.

3. Final Answer:

   Sales data only for 'East' and 'West' regions. -> Option D

4. Quick Check:

   Visual-level filter limits data shown = filtered regions only [OK]

Hint: Visual-level filters show only selected values in that visual. [OK]

Common Mistakes:

• Assuming filter excludes selected values instead of including
• Thinking filter applies to all report visuals
• Believing multiple selections cause errors

4. You applied a visual-level filter on a table visual to show only sales from 2023, but the visual still shows data from 2022. What is the most likely reason?

medium

A. The filter was applied to the page-level filters instead of visual-level filters.

B. The visual-level filter pane was cleared accidentally.

C. The field used in the filter is not the date field but a related text field.

D. The data model does not contain any sales data for 2023.

Solution

1. Step 1: Check the field used in the visual-level filter

   If the filter uses a text field related to date instead of the actual date field, the filter condition may not work as expected.

2. Step 2: Verify the filter application and data presence

   If the filter was applied correctly and data exists for 2023, but the wrong field is filtered, the visual shows incorrect data.

3. Final Answer:

   The field used in the filter is not the date field but a related text field. -> Option C

4. Quick Check:

   Wrong filter field causes unexpected visual data [OK]

Hint: Always filter using the correct field type matching data. [OK]

Common Mistakes:

• Assuming filter applies if placed in wrong filter pane
• Not verifying the field type used in filter
• Ignoring data availability in the model

5. You have a report page with multiple visuals showing sales data. You want one visual to show only sales from the 'Online' channel without affecting other visuals. How should you apply the filter?

hard

A. Create a slicer for sales channel and select 'Online'.

B. Apply a visual-level filter on the sales channel field set to 'Online' on that visual only.

C. Apply a page-level filter on the sales channel field set to 'Online'.

D. Modify the data model to exclude all other channels except 'Online'.

Solution

1. Step 1: Identify filter scope needed

   Since only one visual should show 'Online' sales, the filter must be limited to that visual.

2. Step 2: Choose the correct filter type

   Visual-level filters apply only to one visual, page-level filters or slicers affect multiple visuals, and modifying the data model affects all data.

3. Final Answer:

   Apply a visual-level filter on the sales channel field set to 'Online' on that visual only. -> Option B

4. Quick Check:

   Visual-level filter = single visual filter [OK]

Hint: Use visual-level filter to isolate data on one visual only. [OK]

Common Mistakes:

• Using page-level filter which affects all visuals
• Using slicer which filters multiple visuals
• Changing data model unnecessarily