Apply Custom Conditional Formatting to Clustered Column Chart in Power BI

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

Conclusion

Applying conditional formatting to chart visuals is a game-changer that enables us to have deeper insights in our dataset

Posted in Blog and tagged .

Leave a Reply

Your email address will not be published. Required fields are marked *