Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataMedium
A logistics manager needs a Power BI report to track the on-time delivery performance of various shipping carriers. The dataset includes 'Carrier Name', 'Shipment ID', 'Delivery Date', and 'Scheduled Delivery Date'. The manager wants a visual that displays the percentage of on-time deliveries for each carrier and allows for a quick comparison against an overall company target of 95% on-time delivery. The visual should be concise and easily interpretable at a glance. Which visual type is most appropriate?
- AMulti-row card with conditional formatting
- BScatter chart
- CTable visual with sparklines
- DFunnel chart
Show answer & explanationAnswer & explanation
Correct answer: A. Multi-row card with conditional formatting
A multi-row card can display the 'Percentage On-Time' for each carrier clearly. By applying conditional formatting to the background or font color of each carrier's percentage based on the 95% target, the manager can instantly identify which carriers are meeting or missing the target, fulfilling the concise and glanceable requirement.
Why the other options are wrong
- B. A scatter chart shows relationships between two numerical variables, not individual performance metrics for discrete categories.
- C. A table visual with sparklines shows trends but doesn't offer the same immediate 'pass/fail' visual cue against a target as conditional formatting on a card.
- D. A funnel chart shows stages in a process, not individual performance against a target.
Multi-row Card with Conditional Formatting
A Power BI visual used to display multiple rows of data, often key performance indicators (KPIs), where each row can have conditional formatting applied to highlight performance against targets or thresholds.
- Excellent for displaying multiple KPIs or categorized metrics.
- Conditional formatting enhances immediate understanding of performance.
- Concise and effective for dashboard summaries.
Memory trick: Cards Show Score, Color Tells More