Forum Discussion
How can I set different Conditional Formatting rules for columns and for totals?
Hi! You can create separate measures for each of the items that would be taken care of through the columns - this will allow you to set a rule for each individually, including your total.
Hi! You can create separate measures for each of the items that would be taken care of through the columns - this will allow you to set a rule for each individually, including your total.
Wow. It's amazing how you can be staring a problem in the face for so long, that you forget to take a step back and see that there's a really simple solution.
For my data, the three TrainingCategories haven't changed in a couple years so creating three seperate measures for each, and then a 4th measure to handle totals was exactly what I needed. I can apply seperate conditional formatting for each column, which is great if the requirements per category ever change in the future.
Thank you so much for the simple, painless solution!
