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. goes beyond the target line) and turn "Green" if it is at or under the weekly bedget (i.e. equal to or below target line).
Conditional formatting option is available in matrix and table. Is it also possible in charts and other visualizations? Kindly assist. Any inputs are much appreciated!
Thanks & Regards,
Anuj
Line & Column Chart - Turn "Red" if above target line - Conditional formatting
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.
4 Replies
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.
LinkedInHi 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.
