Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataMedium
A sales manager wants a Power BI report that allows them to quickly compare the sales performance of individual sales representatives against the team average and the overall company average. The report needs to highlight representatives who are significantly above or below these benchmarks. Which type of chart is best suited for visualizing a single measure against multiple benchmarks effectively?
- AScatter chart
- BLine chart
- CWaterfall chart
- DBullet chart
Show answer & explanationAnswer & explanation
Correct answer: D. Bullet chart
A bullet chart is specifically designed to display a single primary measure (e.g., sales representative's sales) in comparison to one or more target measures (e.g., team average, company average) and qualitative ranges (e.g., poor, satisfactory, good).
Why the other options are wrong
- A. A scatter chart shows the relationship between two numerical variables, not for comparing a single measure to benchmarks.
- B. A line chart is best for showing trends over time, not comparing a single measure against multiple benchmarks.
- C. A waterfall chart shows how an initial value is affected by a series of positive or negative changes, not for benchmark comparison.
Bullet Chart
A bullet chart is a variation of a bar chart developed by Stephen Few. It displays a primary measure, compares it to one or more target measures, and provides qualitative ranges (e.g., good, bad, satisfactory) to give context and indicate performance.
- Compares a single measure to multiple targets/benchmarks.
- Includes qualitative ranges for performance context.
- Efficient use of space, high data density.
Memory trick: Aim for the target, shoot for the best, a bullet chart puts your performance to the test.