Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataEasy
A data analyst is designing a Power BI report to visualize the sales performance of different product categories over time. The report needs to clearly show both the overall trend of sales for each category and how each category contributes to the total sales for any given period. Which Power BI visual is BEST suited for this requirement?
- ALine Chart
- B100% Stacked Area Chart
- CClustered Column Chart
- DStacked Bar Chart
Show answer & explanationAnswer & explanation
Correct answer: B. 100% Stacked Area Chart
The 100% Stacked Area Chart is ideal for showing the trend of individual parts over time while simultaneously illustrating their proportion to the whole. It combines the temporal trend of a line chart with the proportional representation of a stacked chart.
Why the other options are wrong
- A. A Line Chart shows trends over time but does not easily represent the proportional contribution of categories to a total.
- C. A Clustered Column Chart compares values across categories at discrete points but does not show overall trends or proportional contributions effectively over time.
- D. A Stacked Bar Chart shows absolute values and their contribution to a total at discrete points, not continuous trends over time.
100% Stacked Area Chart
A visual that displays the trend of multiple series over time, where each series is stacked on top of another and scaled to represent its percentage contribution to the total at each point in time.
- Shows proportional contribution of parts to a whole over time.
- Good for comparing relative trends, not absolute values.
- Each stack represents 100% of the total at a given point.
Memory trick: Charts help tell tales, each with its own proportional scale.