Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataMedium
A sales manager reviews a Power BI report daily to track regional sales performance. The manager needs to quickly identify regions where sales have dropped by more than 10% compared to the previous day. Which visual enhancement would best highlight these underperforming regions without requiring manual data scanning?
- AApply conditional formatting to the sales values.
- BAdd a tooltip displaying the percentage change on hover.
- CCreate a new measure calculating the daily percentage change.
- DImplement a drill-through page for detailed regional data.
Show answer & explanationAnswer & explanation
Correct answer: A. Apply conditional formatting to the sales values.
Conditional formatting allows you to dynamically change the appearance of data points based on specified rules, such as color-coding cells or bars when a value falls below a certain threshold (e.g., a 10% drop). This provides an immediate visual cue for underperforming regions.
Why the other options are wrong
- B. A tooltip provides information on demand but doesn't proactively highlight issues; the manager would still need to hover over each region.
- C. While creating a new measure for daily percentage change is necessary, it's the conditional formatting applied to that measure (or the sales value based on that measure) that provides the visual highlighting.
- D. A drill-through page provides more detail after an interaction but doesn't immediately highlight underperforming regions on the main report.
Conditional Formatting
A Power BI feature that applies formatting (e.g., colors, icons, data bars) to visual elements based on the values in the data, making it easier to identify patterns, trends, and outliers.
- Enhances readability and highlights important data.
- Can be applied to tables, matrices, and other visuals.
- Rules can be based on numbers, percentages, or field values.
Memory trick: Color-code the bad, the good, the ugly, conditional formatting makes data less fuzzy.