Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataEasy
A logistics company uses a Power BI report to track the status of its shipments. The report has a table visual that displays shipment ID, origin, destination, and current status (e.g., 'In Transit', 'Delivered', 'Delayed'). The logistics manager wants to quickly identify delayed shipments by making the 'Status' column turn red when the status is 'Delayed'. Which feature should be used to achieve this visual highlight?
- AData categories
- BConditional formatting
- CReport tooltips
- DField parameters
Show answer & explanationAnswer & explanation
Correct answer: B. Conditional formatting
Conditional formatting allows you to apply formatting rules (like changing background color, font color, or adding icons) to cells in a table or matrix based on their values. This is ideal for visually highlighting 'Delayed' shipments.
Why the other options are wrong
- A. Data categories classify data types (e.g., city, URL) for better functionality, not for conditional styling.
- C. Report tooltips provide additional information when hovering over data points, not conditional styling of cells.
- D. Field parameters allow dynamic selection of fields in a visual, not conditional styling.
Power BI Conditional Formatting
Conditional formatting in Power BI allows you to apply visual formatting (e.g., colors, icons, data bars) to data points or cells in tables and matrices based on specified rules or conditions, making it easier to highlight key information.
- Applies visual styles based on data values.
- Can be used for background color, font color, data bars, icons, and web URLs.
- Applicable to tables, matrices, and some other visuals.
Memory trick: Colors and icons, conditions they meet, make your data speak, oh so sweet.