Analyzing and Visualizing Data with Microsoft Power BI — Question 106

You have a Power BI report that displays a bar chart and a donut chart on the same page. The bar chart shows the total sales by year and the donut chart shows the total sale by category.
You need to ensure that when you select a year on the bar chart, the donut chart remains unchanged.
What should you do?

Answer options

• A. Edit the interactions from the Format menu.
• B. Set a visual level filter on the bar chart.
• C. Set a visual level filter on the donut chart.
• D. Add a slicer to the page that uses the year column.

Correct answer: A

Explanation

The correct answer is A because editing the interactions allows you to specify how visuals affect each other, ensuring the donut chart does not respond to selections made on the bar chart. Options B and C are incorrect as filters would change the data displayed in the visuals, while option D would create a slicer that influences both charts, which is not the desired outcome.