Forum Discussion
Helper IIHow to apply conditional formatting to individual Column Category in a clustered column chart?
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.
Helper IIThank you for your reply, but there has been a slight change in the requirements.
Is it possible to accomplish this in a pie chart?
Pass pie is always gray (#e6e6e6)
If Fail percentage is <=8%, the Fail pie should be green
If Fail percentage is >8% and <=10%, the Fail pie should be yellow
If Fail percentage is > 10%, the Fail pie should be red
If Withdraw percentage is <=8%, the Withdraw pie should be green
If Withdraw percentage is >8% and <=10%, the Withdraw pie should be yellow
If Withdraw percentage is > 10%, the Withdraw pie should be red
https://filebin.net/k73pbolb3kmvgolp/PieChartConditionalFormatting.pbix
Solution SupplierNot 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.