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'.