Conditional format chart based on axis title

BA11501Banderso — Tue, 24 May 2022 12:21:24 GMT

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!

Re: Conditional format chart based on axis title

v-yalanwu-msft — Fri, 27 May 2022 08:36:30 GMT

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.

topic Re: Conditional format chart based on axis title in DAX Commands and Tips

Conditional format chart based on axis title

Re: Conditional format chart based on axis title