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...
Need Help
  • 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.

     

v-hashadapu's avatar
v-hashadapu
Icon for Community Support rankCommunity Support
1 year ago

Hi frost789 , I wanted to check with you and see if the provided information was useful. If any of it helped resolve your question, consider marking it as "Accept as Solution" to make it easier for others to find. Let me know if there's anything else I can assist with!