Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataMedium
A retail company uses Power BI to track sales performance across different product categories. The sales manager wants to see the total sales for each category and also clearly identify which categories are performing above or below a predefined sales target of $50,000. The report should visually emphasize these categories without using a separate gauge or card visual for each category. Which visualization technique is most appropriate for this requirement?
- ALine Chart with Trend Lines
- BPie Chart with Data Labels
- CScatter Plot with Reference Lines
- DClustered Column Chart with Conditional Formatting
Show answer & explanationAnswer & explanation
Correct answer: D. Clustered Column Chart with Conditional Formatting
A clustered column chart effectively displays total sales per category. Applying conditional formatting to the columns based on the $50,000 target allows for immediate visual identification of categories performing above or below the target, meeting both requirements efficiently.
Why the other options are wrong
- A. Line charts are better for trends over time, not comparing discrete categories against a target.
- B. Pie charts are poor for precise comparisons between many categories and do not inherently support target-based conditional emphasis.
- C. Scatter plots are for showing relationships between two numerical variables, not for comparing discrete categories against a target.
Conditional Formatting in Charts
Applying colors, icons, or data bars to visual elements (like columns or bars) in a chart based on specific rules or conditions to highlight important data points.
- Enhances data readability and insights.
- Can be applied to various chart types (bar, column, matrix, table).
- Rules can be based on field values, rules, or color scales.
Memory trick: Target Performance: Colors Reveal Success