Welcome to Excel Jet Consult blog post. In this tutorial, we will see how to apply custom conditional formatting to column chart visual. Conditional formatting enables users to easily spot trends and patterns in our data using colors, icons and bars
Column Chart Conditional Formatting
For this example, we want to see Sum of Amount by Month. Note, Sum of Amount is an explicit DAX measure.
- Click on Clustered Column Chart visual
- Drag and drop Month and Sum of Amount into the Axis and Values areas respectively
- Click on the Data colors in the Formatting
- Hover the mouse to the right of default color and click on the inconspicuous three vertical dot line. You will see Conditional Formatting. Click on it. See the caption below
- In the Default color dialogue box as seen in the caption above, check Diverging
- In the Minimum, Center and Maximum dropdowns, select Custom
- In the Minimum, Center and Maximum color selector, select preferred colors
- In the Minimum, Center and Maximum value boxes, enter the following values 30000, 80000, 180000.
- Click OK
In the caption below, we can see that the custom conditional formatting is applied to the clustered column chart. In addition, notice that in the Data colors formatting, we can see fx in the box. This implies that conditional formatting is applied
Switch to other Visuals
When we switch the visual Clustered bar chart, Pie chart, Donut chart, Funnel, Ribbon, Treemap and few more charts, the applied custom conditional formatting takes effect as see in Pie chart below
Applying conditional formatting to chart visuals is a game-changer that enables us to have deeper insights in our dataset