Forum Discussion
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...
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.
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.