5. Conditional formatting

Conditional formatting in dashboards and reports is key to guiding users’ attention to specific performance areas. Compared to charts, tabular reports have higher information density, which makes conditional formatting a lot more useful.

Conditional Formatting - Overview

Conditional formatting can be used to highlight or emphasize certain records using color, icons, data bars, etc.

Click on the measure to which you want to apply the conditional formatting, and then select the Conditional Formatting dropdown, as shown below.

Accessing conditional formatting

There are two ways to apply conditional formatting:

  1. Using quick, one-click options such as quick rules, color scales, classification, and data bars—these are covered in the one-click options.

  2. Creating advanced rules from scratch using nested if-conditions, ranking, etc.—these are covered in the create rule section.

Inserted rules can be edited, hidden, reordered, or deleted using the Manage Rules menu.

After applying the one-click formatting options, they can be further customized.

In the following section, we'll look at one-click conditional formatting options.

5 ways to supercharge your Power BI Conditional Formatting

Last updated