Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataEasy
A data analyst is developing a Power BI report for a call center to monitor agent performance. The report includes a table showing individual agent metrics (e.g., calls handled, average call duration, customer satisfaction score). The call center manager wants to quickly identify agents whose performance is falling below a predefined threshold for any of these metrics, without having to manually scan through all the numbers. Which Power BI feature should the analyst implement to achieve this visual alert?
- AUse the Q&A visual for natural language queries.
- BCreate a custom tooltip for each metric.
- CApply conditional formatting to the table cells.
- DSet up a drill-through page for low-performing agents.
Show answer & explanationAnswer & explanation
Correct answer: C. Apply conditional formatting to the table cells.
Conditional formatting is the ideal feature for visually highlighting specific data points in a table or matrix based on rules (e.g., changing cell background color to red if a metric falls below a threshold), allowing managers to quickly spot underperforming agents.
Why the other options are wrong
- A. Q&A visual allows natural language queries, which is irrelevant for visual alerts based on thresholds.
- B. Custom tooltips provide additional information on hover, not visual alerts for performance thresholds.
- D. Drill-through navigates to another page, which doesn't provide an 'alert' on the current page.
Power BI Conditional Formatting
Conditional formatting in Power BI enables applying visual styles (e.g., colors, data bars, icons) to data points or cells within tables, matrices, and other visuals based on specific rules or conditions, making it easier to identify trends, outliers, or performance issues.
- Highlights data based on rules.
- Supports various formatting types: background color, font color, data bars, icons, web URLs.
- Enhances data readability and quick identification of key information.
Memory trick: Conditions met, colors ignite, making low performers instantly in sight.