Conditional formating in a card by another measure

[Anonymous]

Hi!

I'm trying to set up a conditional formating on a set of measures ([PreviousRevenues], [RevenuesVsPrevious] and more) represented on independent cards based on the same measure [RevenuesVsPrevious]. The conditional formatting is in all cases the exact same:

But instead it only works in the [RevenuesVsPrevious] measure. Does anyone know whats going on and how to fx it?

Thanks!

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You could create a measure to set colors. For example:

color =
IF ( [Measure] > 5, "green", IF ( [Measure] < 3, "red", "yellow" ) )

Then set in the conditional formatting.

Then you could apply it to each field.