Forum Discussion
Helper IIHow 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 able to change the conditional formatting options for All columns,
The conditional formatting button "fx" is not available when I choose a category.
What can I do if I want to make Good Standing to follow a set of conditional formatting rules while have Probation/Suspension to follow a different set of conditional formatting rules?
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.
12 Replies
Ashish_ExcelSolution Supplier
Hi,
Share the download link of the PBI file. Also, clearly state the conditional formatting rules for good standing and Probation.
frost789The 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
v-hashadapuCommunity Support
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!
- v-hashadapu
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!
- v-hashadapu
Hello frost789 , Just getting back to see if the shared details answered your question. If so, marking it as "Accept as Solution" would be greatly appreciated to guide others in the community. Feel free to reach out with any additional questions!
- frost789
I've marked a solution