Table and matrix conditional formatting

Default and custom conditional formatting rules can be applied to table and matrix visuals to make it easier to identify exceptions and outlier values. Power BI currently supports background color scales, font color scales, and data bar conditional formatting for table and matrix visuals. To apply conditional formatting to a table or matrix, click the drop-down arrow next to the field name of the measure (for example, Internet Net Sales) in the Values field well of the Visualizations pane. A conditional formatting menu item will appear with an arrow providing access to the three types of conditional formatting.

In the following table, data bar conditional formatting has been applied to four measures ...

Get Mastering Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.