Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Conditional Formatting for Line and Clustered Column Chart

Hello Power BI Users,   I am seeking help regarding Conditional Formatting for the Line and Clustered Column Chart attahced below. I need the columns to turn "Red" if it exceeds the budget (i.e. go...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    As the reply said above only when you have one column value then you can set conditional formatting.

    You can create measure like

     

    Measure = IF(AVERAGE('Table'[actual])>AVERAGE('Table'[budget]),1,0)

     

     Then create rule as below.

    Result

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

You can click on the three dots next to Default Color as below, this will expand conditional formatting, however it will only show if you have only one value in the visual.

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you! Enabling conditional formatting for any visual with that option is very useful.