Conditional formatting in Card is not working as expected for measures in percentages

[Anonymous]

Hi,

I am using a measure oee2% in the card visualization, This is a percentage field as shown below.

I have created a rule so that all the values above 67 %, the data label should be green, it should show red otherwise,

but for some reason its showing red always and not showing green even when the value is 67 or greater, can you please correct me as to what am i doing wrong here.

[Sean · Accepted solution]

@Anonymous 

The % sign is only a formatting option
67% represents the number 0.67 and 100% represents the number 1.00

So change the 67 to 0.67 and the 100 to 1 in the conditional formatting dialog box

That should do it!😀

[Anonymous]

Thank you. This works. I had actually tried giving it as 0.67 and 1, now i change 1 to 1.00 and 0 as 0.00, it worked fine 🙂

[amitchandak]

Is it defined in conditional formatting, font color?

Seem like correct, unless defined at the wrong place.