Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataEasy
A data analyst is designing a Power BI report to display sales trends over time for a retail company. The report includes a line chart showing total sales by month and a table displaying detailed sales figures. The analyst wants to ensure that when a user selects a specific month in the line chart, the table automatically updates to show only the sales data for that selected month, without affecting other visuals on the page. Which feature should the analyst configure for the interaction between the line chart and the table?
- ACross-highlighting
- BDrill-through
- CFilter
- DSynchronize slicers
Show answer & explanationAnswer & explanation
Correct answer: C. Filter
To make a visual update another visual to show only the selected data, without affecting other visuals, the interaction should be set to 'Filter'. This reduces the data shown in the target visual to only include the data points selected in the source visual.
Why the other options are wrong
- A. Cross-highlighting would dim non-selected data in the table, not remove it entirely.
- B. Drill-through navigates to a different report page with filtered data, not update visuals on the same page.
- D. Synchronize slicers applies the same slicer selection across multiple pages, which is not relevant for direct visual interactions on a single page.
Visual Interaction: Filter
The 'Filter' interaction in Power BI causes a selected visual to filter the data displayed in another visual, showing only the data points related to the selection.
- Reduces the data in the target visual.
- Ideal for showing specific details based on a selection.
- Can be configured in the 'Edit interactions' mode.
Memory trick: Interactions shape how visuals dance; Filter makes one visual dance only with the selected partner.