Skip main navigation

New offer! Get 30% off one whole year of Unlimited learning. Subscribe for just £249.99 £174.99. New subscribers only. T&Cs apply

Find out more

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.

This article is from the free online

Microsoft Power BI: Advanced Data Analysis and Visualisation

Created by
FutureLearn - Learning For Life

Reach your personal and professional goals

Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.

Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.

Start Learning now