Conditional Formatting - font color based on relative value in same table

[Anonymous]

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.

[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 🙂

Website YouTube  LinkedIn

[Fowmy · Accepted solution]

@Anonymous 

Create a measure like:

Flag =

IF(

[Inv Bal Actual] > [Inv Bal AOP] , "RED", "GREEN"

)

Select the Actuals, Conditional Formatting and choose Field Value

________________________

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 🙂

Website YouTube  LinkedIn

[Anonymous]

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).