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
Community SupportHi frost789 , Thank you for reaching out to the Microsoft Community Forum.
Please check below documentation on how to achieve this in a pie chart.
Power BI: Conditional formatting the Pie Visual - Microsoft Fabric Community
If this helped solve the issue, please consider marking it “Accept as Solution” so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.