Forum Discussion
Solved
Conditional format chart based on axis title
Hello, I'm trying to find a way to highlight the "Past due" column. I would like it to show as Red if there is a value. How do I do this? I am using a switch statement to create the headings.
Thank you!
Hi, BA11501Banderso ;
You could create a measure.
Measure = SWITCH(MAX('Table'[column]),"Past Due","red","blue")then apply it into bar color .
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi, BA11501Banderso ;
You could create a measure.
Measure = SWITCH(MAX('Table'[column]),"Past Due","red","blue")then apply it into bar color .
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.