Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataMedium
A manufacturing quality assurance team uses a Power BI report to monitor defects. The report includes a table listing defect types and their counts, as well as a bar chart showing defects by production line. The team wants to enable a feature where, if a user selects a specific defect type in the table, the bar chart automatically updates to show only the production lines affected by that particular defect type, and vice-versa. What Power BI feature allows for this bidirectional filtering and interaction?
- ASynchronize slicers
- BBidirectional cross-filtering in the data model
- CCross-report drill-through
- DEdit interactions (Filter both directions)
Show answer & explanationAnswer & explanation
Correct answer: D. Edit interactions (Filter both directions)
The 'Edit interactions' feature allows you to control how visuals on a report page interact with each other. By setting both the table and the bar chart to 'Filter' each other, selecting an item in either visual will filter the other, achieving the desired bidirectional interaction.
Why the other options are wrong
- A. Synchronize slicers is for ensuring slicers filter consistently across multiple report pages, not for interactive filtering between two different types of visuals.
- B. Bidirectional cross-filtering in the data model (relationship properties) defines how filters propagate through tables, but 'Edit interactions' is the specific feature to configure how *visuals* interact on the report canvas.
- C. Cross-report drill-through navigates to a different report, not for interactive filtering between visuals on the same page.
Power BI Edit Interactions
A feature in Power BI Desktop that allows users to customize how visuals on a report page filter or highlight each other when a selection is made.
- Controls visual-to-visual communication.
- Options include Filter, Highlight, or None.
- Can be configured for one-way or bidirectional interaction.
Memory trick: Edit interactions, set them just right, visuals filter each other, day and night.