Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataHard
A sales director wants a Power BI report to analyze sales performance by territory. The report needs to display both the 'Total Sales' and the 'Sales Growth Percentage' year-over-year for each territory. The director specifically requests a visual that can show both values for each territory side-by-side, allowing for quick comparison while clearly differentiating between the absolute sales value and the percentage change. Which visual type is most effective for this dual-metric comparison?
- ALine and clustered column chart
- BPie chart
- CRibbon chart
- DStacked column chart
Show answer & explanationAnswer & explanation
Correct answer: A. Line and clustered column chart
A line and clustered column chart (often called a combo chart) is ideal for displaying two different types of measures (absolute value and percentage) on the same visual, especially when they have different scales. The columns can represent 'Total Sales' and the line can represent 'Sales Growth Percentage', often using a secondary Y-axis for the percentage to ensure readability.
Why the other options are wrong
- B. A pie chart is for showing proportions of a single total, not for comparing two different measures across categories.
- C. A ribbon chart shows rank changes over time, which isn't the primary goal here.
- D. A stacked column chart is for showing parts of a whole or different categories contributing to a total, not two distinct metrics with different scales.
Line and Clustered Column Chart (Combo Chart)
A Power BI visual that combines a column chart and a line chart, allowing for the display of two different measures, often with different scales, on the same visual.
- Effective for comparing two related measures.
- Can use a secondary Y-axis for different scales.
- Good for showing trends (line) alongside categorical comparisons (columns).
Memory trick: Columns Stand, Lines Flow for Two Tales