Configure Conditional Formatting

Configure Conditional Formatting

Conditional formatting in Power BI Desktop allows you to specify customised cell colours, including colour gradients, that are based on field values. Additionally, you can use conditional formatting to represent cell values with data bars, KPI icons, or active web links.

Conditional Formatting – Example

In this example, you will select the table visualisation and then, in the Format pane, expand the Conditional formatting section. Turn on the Background colour option, and then select the Advanced controls option. In the window that displays, set a condition to change background colour to red for cells that have low values and green for cells with high values.

The Power BI conditional formatting function will automatically detect the highest and the lowest number in each column and will apply background colouring according to the values.

If you want to remove the conditional formatting that you set, select the Values tab on the Visualisations pane and right-click the value (field) that you set the formatting for. Select Remove conditional formatting and then select the type of formatting that you want to remove, for example All or Background colour.