Forum Discussion

frost789's avatar
frost789
Icon for Helper II rankHelper II
1 year ago
Solved

How to apply conditional formatting to individual Column Category in a clustered column chart?

I have the following visual, I'd like to apply a conditional formatting (change a column's color) individually without changing the other column's conditional formatting options    I'm only a...
  • Ashish_Excel's avatar
    Ashish_Excel
    1 year ago

    Not sure of how to colour the slices of a pie chart but this measure will colour the data labels by going to Format > Details Labels > Values > Color.  Ratio is the same measure as shared earlier.

    Colour measure = if(MIN('Dup Data'[PFW])<>"Pass",if([Ratio]<=0.08,"Green",if([Ratio]<=0.10,"Yellow","Red")),"Grey")

    Hope this helps.