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 col...
Anonymous
Create a measure like:
Flag =IF([Inv Bal Actual] > [Inv Bal AOP] , "RED", "GREEN")Select the Actuals, Conditional Formatting and choose Field Value
Fowmy
Super User
Super UserAnonymous
Create a measure like:
Flag =
IF(
[Inv Bal Actual] > [Inv Bal AOP] , "RED", "GREEN"
)
Select the Actuals, Conditional Formatting and choose Field Value
Thank 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).