Microsoft Certified Power Bi Data Analyst Associate · Free Practice Question Medium
Question 32
You are building a sales performance report in Power BI. The report contains the following visuals:
A pie chart showing the percentage of sales by product category.
A line chart showing the monthly total revenue trend.
The sales manager wants to see how each product category contributes to the monthly revenue trend without filtering out other product categories.
How should you configure the interaction between the pie chart and the line chart?
-
A
Apply filtering to display only the selected product category.
-
B
Enable proportional highlighting to show contributions for the selected category.
-
C
Disable all interactions between the visuals.
-
D
Show values as a tooltip when hovering over the product category.
Reveal correct answer
Correct answer: B
Explanation
In Power BI, visual interactions play a crucial role in data exploration and analysis. When multiple visuals are present, users can configure how interactions affect each other to provide better insights.
Key Visual Interaction Options in Power BI:
Filtering: Selecting a value in one visual filters the data in another visual, showing only the relevant subset. While useful, this removes other values, which is not ideal in this scenario. Learn more about Filtering in Power BI Visuals.
Highlighting: This keeps all data visible but emphasizes the selected value, making it easy to compare contributions within the overall dataset. Proportional highlighting is the best choice here, as it allows users to see the total monthly revenue trend while also highlighting the selected product category’s contribution. Read more about Highlighting in Power BI.
Tooltips: Display additional details on hover, but they do not modify how data is presented in a visual. They are helpful but do not meet the requirement of emphasizing a category’s contribution within the trend. More details on Tooltips in Power BI.
Disabling Interactions: Prevents any relationship between visuals, which is not useful in scenarios where users want to explore data dynamically.
By enabling proportional highlighting, the sales manager can effectively see how each product category contributes to the monthly revenue trend, without losing visibility into other categories, making it the best approach.
A.
Filtering removes the other product categories, which does not allow for a comparison of the selected category’s contribution to the total revenue trend.
B.
Proportional highlighting allows the line chart to display the total monthly revenue trend while emphasizing the contribution of the selected product category. This meets the requirement perfectly.
C.
Disabling interactions prevents any analysis of how a product category contributes to the overall trend, making it an ineffective approach.
D.
Using tooltips does not meet the requirement of showing the contribution of the selected category within the monthly revenue trend. Tooltips only provide additional details when hovering but do not visually emphasize the category’s contribution.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
