Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataMedium
A financial analyst is building a Power BI dashboard to monitor key financial metrics. The dashboard includes multiple visuals, such as a line chart for stock prices, a card for current market capitalization, and a table for recent transactions. The analyst wants to ensure that when a user selects a specific transaction in the table, all other visuals on the dashboard automatically update to reflect data related only to that transaction. Which interaction behavior should be configured for the table visual?
- AHighlight
- BEdit interactions
- CDrill through
- DFilter
Show answer & explanationAnswer & explanation
Correct answer: D. Filter
When a visual is configured to 'Filter' other visuals, selecting an item in the source visual (the table in this case) will filter the data displayed in the target visuals, showing only the data related to the selected item. This is the desired behavior for cross-filtering the entire dashboard.
Why the other options are wrong
- A. 'Highlight' will dim the unselected data points in other visuals, but still show the full context, which is not the desired behavior of showing *only* data related to the selected transaction.
- B. 'Edit interactions' is the mode used to configure the interaction behavior, but 'Filter' is the specific behavior to select.
- C. 'Drill through' navigates to a different report page with filtered details, rather than updating visuals on the current page.
Power BI Visual Interactions: Filter
A configuration option in Power BI that, when enabled, causes selection in one visual to filter the data displayed in other visuals on the same report page, showing only the data related to the selection.
- One of three main interaction types (Filter, Highlight, None).
- Filters target visuals to show only relevant data.
- Configured via 'Edit interactions' mode.
Memory trick: Interact, filter, highlight, or nothing at all, Power BI visuals stand tall.