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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
