Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataEasy
A production manager uses a Power BI report to monitor manufacturing defects. The report includes a column chart showing defect counts by product line and a pie chart showing the percentage breakdown of defect types. The manager notices that when they click on a specific product line in the column chart, the pie chart dims the other defect types but still shows all of them, making it difficult to focus only on the defect types for the selected product line. The manager wants the pie chart to exclusively display the defect types relevant to the selected product line. Which interaction setting needs to be adjusted?
- ASet up a drill-through filter from the column chart to the pie chart.
- BChange the interaction from 'Cross-highlight' to 'Filter'.
- CChange the interaction from 'Filter' to 'Cross-highlight'.
- DDisable interaction between the two visuals.
Show answer & explanationAnswer & explanation
Correct answer: B. Change the interaction from 'Cross-highlight' to 'Filter'.
The current behavior, where other defect types are dimmed, indicates a 'Cross-highlight' interaction. To make the pie chart show only the defect types for the selected product line, the interaction needs to be changed to 'Filter', which removes unselected data from the target visual.
Why the other options are wrong
- A. Drill-through navigates to a new page, which is not what the manager wants for interaction on the same page.
- C. Changing from Filter to Cross-highlight would dim data, which is the opposite of the desired outcome.
- D. Disabling interaction would mean clicking the column chart has no effect on the pie chart, which is not desired.
Visual Interaction: Cross-highlight vs. Filter
Power BI visuals can interact in two primary ways: 'Cross-highlight' dims unselected data while keeping it visible, whereas 'Filter' removes unselected data, showing only the selected portion in the target visual.
- Cross-highlight: dims unselected, keeps all data points.
- Filter: removes unselected, shows only selected data points.
- Configured in 'Edit interactions' mode.
Memory trick: Highlight dims, Filter hides; choose wisely how your data abides.