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 hope you're doing well! Just checking in to see if you had a chance to review the details shared earlier. If any of the information addressed your needs, feel free to mark it as "Accept as Solution"  to help others in the community. Please let me know if you have any further questions!