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.
Solution SupplierHi,
Share the download link of the PBI file. Also, clearly state the conditional formatting rules for good standing and Probation.
Helper IIThe PBIX file is available at the following link
https://filebin.net/t9vmj7we59n3xgpi/ConditionalFormatting.pbix
The rules are as follows:
My attempt is to have "Good Standing" column staying at blue (say that's our school color, we always want it blue). "Probation/Suspension" changes colors with the above rules. Thank you!
- Ashish_Excel
Hi,
I wrote this measure
Colour measure = if(MIN(Undup[PROB/SUSP])="Good standing","Blue",if([StudentCount]>10,"Red",if([StudentCount]>8,"yellow","Green")))Then under Visual > Column > fx, did this
to get this result
- frost789
I appreciate your help. However, the conditions are not correct (please refer to the "rules" screenshot. They are in percentages). It's red only if:
("Probation/Suspension" count)/ ("Probation/Suspension" Count + "Good Standing" Count) >= 0.1 then "red"
("Probation/Suspension" count)/ ("Probation/Suspension" Count + "Good Standing" Count) >= 0.08 but less than 0.1 then "yellow"
- Ashish_Excel
Hi,
Try these measures
All student count = CALCULATE([StudentCount],ALL(Undup[PROB/SUSP]))Ratio = DIVIDE([StudentCount],[All student count])Colour measure = if(MIN(Undup[PROB/SUSP])="Good standing","Blue",if([Ratio]>0.1,"Red",if([Ratio]>0.08,"yellow","Green")))Drag the colour measure to Visual > Column fx