Home » Microsoft » DA-100 » You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month.
You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month.
You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.
How should the visual interactions be set on the column chart when the bar chart is selected?
A. no impact
B. highlight C. filter
C. filter
Correct Answer: C
Explanation/Reference:
Filters remove all but the data you want to focus on. Highlighting isn’t filtering. It doesn’t remove data, but instead highlights a subset of the visible data; the data that isn’t highlighted remains visible but dimmed.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
