Forum Discussion

BA11501Banderso's avatar
BA11501Banderso
Frequent Visitor
4 years ago
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.    ...
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

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.