Cross-filtering between visuals in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

How does cross-filtering affect visuals in Power BI?

Imagine you have two charts on a Power BI report page: a bar chart showing sales by product category and a pie chart showing sales by region. If you click a bar representing a category, what happens to the pie chart?

A The bar chart resets to show all categories again.

B The pie chart remains unchanged and shows sales for all categories.

C Both charts clear their filters and show all data.

D The pie chart updates to show sales only for the selected product category.

💡 Hint

Think about how selecting data in one visual affects others on the same report page.

Cross-filtering means selecting data in one visual filters the data in other visuals on the page. So, clicking a bar filters the pie chart to show only related data.

❓ dax_lod_result

intermediate

DAX measure result with cross-filtering

You have a measure Total Sales = SUM(Sales[Amount]). On a report page, a slicer filters the 'Region' column to 'East'. What is the result of Total Sales in a card visual?

Power BI

Total Sales = SUM(Sales[Amount])

A Sum of sales amounts only for the 'East' region.

B Sum of sales amounts for all regions ignoring slicer.

C Sum of sales amounts for regions except 'East'.

D Zero, because slicers do not affect measures.

💡 Hint

Remember slicers apply filters to visuals and measures.

The measure respects the filter context from slicers. So, it sums sales only for the 'East' region.

❓ visualization

advanced

Configuring cross-filtering behavior between visuals

You want a scatter chart to filter a table visual when points are selected, but the table should not filter the scatter chart. How do you configure this in Power BI?

A Set the scatter chart's visual interaction on the table to 'Filter' and the table's interaction on the scatter chart to 'None'.

B Set both visuals to 'Highlight' interaction on each other.

C Set both visuals to 'Filter' interaction on each other.

D Set the scatter chart's interaction on the table to 'None' and the table's on scatter chart to 'Filter'.

💡 Hint

Check the 'Edit interactions' feature in Power BI visuals.

To have one visual filter another but not vice versa, set the first visual's interaction on the second to 'Filter' and the second visual's interaction on the first to 'None'.

🔧 Formula Fix

advanced

Why does cross-filtering not work between two visuals?

You have two visuals on a report page, but selecting data in one does not filter the other. Which of the following is the most likely cause?

A The visuals are on different report pages.

B The data model has too many columns.

C The two visuals are based on unrelated tables without a relationship.

D The visuals use different color themes.

💡 Hint

Think about how Power BI connects data between visuals.

Cross-filtering requires a relationship between tables used by the visuals. Without it, filters cannot propagate.

🎯 Scenario

expert

Designing cross-filtering for complex report interactions

You have a report with three visuals: a slicer for Year, a bar chart for Product Category, and a line chart for Monthly Sales. You want the slicer to filter both charts, the bar chart to filter the line chart, but the line chart should not filter any other visual. Which setup achieves this?

A Use slicer to filter line chart only; set bar chart interaction on slicer to 'Filter'; set line chart interaction on bar chart to 'Filter'.

B Use slicer to filter both charts; set bar chart interaction on line chart to 'Filter'; set line chart interactions on slicer and bar chart to 'None'.

C Use slicer to filter bar chart only; set line chart interaction on bar chart to 'Filter'; set bar chart interaction on slicer to 'None'.

D Use slicer to filter both charts; set line chart interaction on bar chart to 'Filter'; set bar chart interaction on line chart to 'None'.

💡 Hint

Remember slicers filter all visuals by default. Use 'Edit interactions' to control filtering directions.

The slicer filters both charts by default. To have bar chart filter line chart but not vice versa, set bar chart's interaction on line chart to 'Filter' and line chart's interactions on others to 'None'.

Practice

1. What does cross-filtering between visuals in Power BI allow you to do?

easy

A. Export data from all visuals at once

B. Change the color scheme of all visuals simultaneously

C. Click one visual to filter data in other visuals on the report page

D. Automatically refresh data sources without user action

Solution

1. Step 1: Understand cross-filtering purpose

   Cross-filtering links visuals so selecting data in one affects others.

2. Step 2: Identify correct behavior in Power BI

   Clicking a visual filters related data in other visuals on the same report page.

3. Final Answer:

   Click one visual to filter data in other visuals on the report page -> Option C

4. Quick Check:

   Cross-filtering = interactive filtering [OK]

Hint: Cross-filtering links visuals by selection to filter others [OK]

Common Mistakes:

• Thinking cross-filtering changes colors
• Confusing cross-filtering with data export
• Assuming it refreshes data automatically

2. Which setting in Power BI controls how one visual filters another?

easy

A. Data source credentials

B. Cross-filtering options in the Format pane

C. Page size settings

D. Visual title text

Solution

1. Step 1: Locate cross-filtering controls

   Power BI allows customizing cross-filtering behavior in the Format pane of visuals.

2. Step 2: Identify correct setting

   The Format pane includes options to set cross-filtering or cross-highlighting between visuals.

3. Final Answer:

   Cross-filtering options in the Format pane -> Option B

4. Quick Check:

   Cross-filtering setting = Format pane option [OK]

Hint: Cross-filtering settings are in Format pane, not data or page settings [OK]

Common Mistakes:

• Confusing cross-filtering with data source settings
• Looking in page size or title settings
• Assuming cross-filtering is automatic without configuration

3. Given two visuals: a bar chart showing sales by region and a table showing customer details, what happens if you click a bar for 'West' region when cross-filtering is enabled?

medium

A. The table updates to show only customers from the West region

B. The bar chart changes to show only customers from the West region

C. Nothing changes in either visual

D. The table shows all customers regardless of region

Solution

1. Step 1: Understand cross-filtering effect on visuals

   Clicking a bar filters related visuals to show data matching that selection.

2. Step 2: Apply to given visuals

   Clicking 'West' bar filters the customer table to only show customers from West region.

3. Final Answer:

   The table updates to show only customers from the West region -> Option A

4. Quick Check:

   Click bar filters table data [OK]

Hint: Clicking a visual filters related visuals to matching data [OK]

Common Mistakes:

• Thinking the bar chart itself changes
• Assuming no change happens
• Believing the table shows all customers always

4. You set cross-filtering between two visuals, but clicking one visual does not filter the other. What is the most likely cause?

medium

A. The data model has no relationship between the tables used

B. Cross-filtering is disabled or set to 'None' in Format pane

C. The visuals are on different report pages

D. The report is in Reading view instead of Editing view

Solution

1. Step 1: Check data model relationships

   Cross-filtering requires a relationship between tables used in visuals to filter correctly.

2. Step 2: Identify cause of no filtering

   If no relationship exists, visuals cannot filter each other despite cross-filtering settings.

3. Final Answer:

   The data model has no relationship between the tables used -> Option A

4. Quick Check:

   Missing relationship blocks cross-filtering [OK]

Hint: Check data relationships if cross-filtering fails [OK]

Common Mistakes:

• Assuming visuals on different pages can cross-filter
• Ignoring data model relationships
• Thinking view mode blocks filtering

5. You have a report with a slicer visual filtering product categories and a bar chart showing sales by region. You want selecting a region in the bar chart to also filter the slicer to only show categories sold in that region. How do you configure this cross-filtering behavior?

hard

A. Disable cross-filtering in the Format pane for both visuals

B. Set the slicer visual to ignore cross-filtering from the bar chart

C. Place both visuals on separate report pages

D. Enable bi-directional cross-filtering between the product and region tables in the data model

Solution

1. Step 1: Understand cross-filtering direction

   By default, filtering flows one way; to filter slicer from bar chart, bi-directional filtering is needed.

2. Step 2: Configure data model relationships

   Enable bi-directional cross-filtering between product and region tables to allow filtering both ways.

3. Final Answer:

   Enable bi-directional cross-filtering between the product and region tables in the data model -> Option D

4. Quick Check:

   Bi-directional filtering enables slicer update from bar chart [OK]

Hint: Use bi-directional filtering to sync slicer and chart filters [OK]

Common Mistakes:

• Ignoring filtering direction in relationships
• Putting visuals on different pages
• Disabling cross-filtering accidentally