Skip main navigation

£199.99 £139.99 for one year of Unlimited learning. Offer ends on 28 February 2023 at 23:59 (UTC). 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

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education