Card with Conditional Formatting

[Anonymous]

I am trying to do what i thought would be a simple task with a card and it's driving me insane!

I have a card which shows % vs target using a meaure field and I have another measure which calculates what the % should be at this point in the year.  All I want to do is compare one against the otgher and colour the card green or red based on this and I can't for the life of me get this to work.  Is anyone able to help me?

[Anonymous]

Hi @Anonymous ,

I think below is what you want:

Please try.

Aiolos Zhao

[Anonymous]

Hi, I want to use a calculated measure to achieve this result but the conditional formatting by field selector won't allow me to select the field I need

[Anonymous]

Hi @Anonymous ,

I'm not sure why you can't select the measure you need, because it works on my desktop.

if it's possible, could you please share you measure expression.

In my sample, I choose the "Format by Field Value", then select the measure I created.

Aiolos Zhao

[Anonymous]

Sure it's just a simple division.  Tried as a measure and column and it won't allow me to click OK

PTD % Target = DIVIDE([Days PTD],[Days in Period])

[Anonymous]

Hi @Anonymous ,

Sorry for reply late, yes, for this measure you can't use "Format by Field Value",

for this measure, you need to use "Format by Color Scale", then choose the range then color that you want.

Please try.

Aiolos Zhao