Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataEasy
A data analyst is designing a Power BI report to visualize sales performance. The report includes a slicer for 'Region' and a bar chart displaying 'Total Sales by Product Category'. The analyst wants to ensure that when a user selects a region in the slicer, the bar chart filters to show only the sales for that selected region, while other visuals on the page remain unaffected by the slicer's selection. Which Power BI feature should the analyst configure?
- AEdit Interactions
- BBookmarks
- CDrill-through
- DField Parameters
Show answer & explanationAnswer & explanation
Correct answer: A. Edit Interactions
Edit Interactions allows precise control over how visuals on a report page respond to selections in other visuals. By editing interactions, the analyst can set the slicer to filter the bar chart while leaving other visuals untouched.
Why the other options are wrong
- B. Bookmarks save the current state of a report page, including filters and selections, for later recall, not dynamic interaction control.
- C. Drill-through navigates to a different report page based on a selection, not control interactions on the same page.
- D. Field Parameters allow users to dynamically change the measures or dimensions used in a visual, not control interaction behavior.
Edit Interactions
A Power BI feature that enables report designers to control how different visuals on a report page filter or highlight each other when a selection is made.
- Controls visual filtering/highlighting behavior.
- Accessible from the 'Format' tab when a visual is selected.
- Allows 'Filter', 'Highlight', or 'None' interaction types.
Memory trick: Interactions Link Visuals Smoothly