Conditional format chart based on axis title

[BA11501Banderso]

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!

[v-yalanwu-msft · Accepted solution]

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.