Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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

    That should do it!😀

3 Replies

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion

    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's avatar
      Anonymous
      Not 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 🙂

  • Is it defined in conditional formatting, font color?

     

    Seem like correct, unless defined at the wrong place.