Forum Discussion
Conditional Formatting - font color based on relative value in same table
Hi all - wondering if anyone knows how to conditionally format a column (font color) based on it's value relative to another column? Example - below, if the Actuals column is greater than the AOP column, I'd like the font color of the Actuals column to be red. If the Actuals column is less than the AOP column, I'd like it to be green.
Anonymous
Create a measure like:
Flag =IF([Inv Bal Actual] > [Inv Bal AOP] , "RED", "GREEN")Select the Actuals, Conditional Formatting and choose Field Value
3 Replies
- Fowmy
Super User
Anonymous
Create a measure like:
Flag =IF([Inv Bal Actual] > [Inv Bal AOP] , "RED", "GREEN")Select the Actuals, Conditional Formatting and choose Field ValueThank you, Fowmy! After creating [Inv Bal Actual] and [Inv Bal AOP] as measures themselves, this worked perfectly.
Follow up question - is there a better way to create these measures than inputting the following formula
Inv Bal Actual = CALCULATE(SUM(Amsterdam[Inventory Balance - Actuals])) ? Perhaps there is some way to transform the data before this or another way to avoid having to create lots of measures (just to be used in the Flag measure, for example).
- Fowmy
Anonymous
You do not need to use CALCULATE as you are not modifying any initial filter context.Inv Bal Actual = SUM(Amsterdam[Inventory Balance - Actuals])
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply 🙂