Get startedGet started for free

Conditional formatting

Conditional formatting is a great tool for displaying color when certain conditions are met. These can be cases when the situation is particularly good or particularly bad, but in either event, the change in color will draw the eye. In this exercise, we will go back to a visual created in a previous exercise and edit it so that a neutral color is used for certain products over a total sales amount threshold but show a different color for products that do not reach the £5,000 total sales amount threshold.

If you have lost any progress, close any open reports and reload 4_4_conditional_formatting.pbix from the Exercises folder on the desktop.

This exercise is part of the course

Data Visualization in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise