Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataHard
A financial analyst is building a Power BI report to monitor investment portfolio performance. The report includes a table of various stocks and their current 'Price', '52-Week High', and '52-Week Low'. The analyst wants to create a visual that quickly shows for each stock where its current 'Price' stands relative to its '52-Week High' and '52-Week Low', without showing the exact price values, but rather a relative position on a scale from low to high. Which visual type is best suited for this comparison?
- AStacked bar chart
- BBullet chart
- CScatter plot
- DDoughnut chart
Show answer & explanationAnswer & explanation
Correct answer: B. Bullet chart
A bullet chart is specifically designed for comparing a single primary measure (current 'Price') against one or more target measures (e.g., '52-Week Low' and '52-Week High') and qualitative ranges (e.g., 'good', 'average', 'bad'). It effectively shows the current value's position within a defined range, making it ideal for visualizing where stock prices stand relative to their historical high and low points.
Why the other options are wrong
- A. A stacked bar chart shows parts of a whole or categories contributing to a total, not a single value's position within a range.
- C. A scatter plot shows relationships between two numerical variables, not a single value's position relative to a range.
- D. A doughnut chart shows proportions of a whole, not a value's position within a defined range.
Bullet Chart
A variation of a bar chart designed to display a primary measure, one or more comparative measures (targets), and qualitative ranges (performance zones) in a compact form.
- Efficiently compares actual vs. target performance.
- Shows qualitative ranges (e.g., poor, average, good).
- Compact and ideal for dashboards with many KPIs.
Memory trick: Bullet Hits Target, Shows Range