Forum Discussion
Conditional formatting in Card is not working as expected for measures in percentages
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.
Anonymous
The % sign is only a formatting option
67% represents the number 0.67 and 100% represents the number 1.00So change the 67 to 0.67 and the 100 to 1 in the conditional formatting dialog box
That should do it!😀
3 Replies
- Sean
Community Champion
Anonymous
The % sign is only a formatting option
67% represents the number 0.67 and 100% represents the number 1.00So change the 67 to 0.67 and the 100 to 1 in the conditional formatting dialog box
That should do it!😀
- AnonymousNot applicable
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
Super User
Is it defined in conditional formatting, font color?
Seem like correct, unless defined at the wrong place.