Forum Discussion

markus123's avatar
markus123
Frequent Visitor
5 years ago
Solved

Conditional Formatting: Font color

Hello!

 

I need some help with the formatting of font color, please. I have a Matrix table for KPI's.

Everything below the target should be red, everything about green.

Below you can see the table and my setting for the font color and i dont understand, why the KPI "93,7%" is red.

The target is 90%, so it seems that i did something wrong. Thanks in advance for your help!

 

 

 

  • The "Percent" copmpare is looking at the portion of the dataset, not the output of the measure.  Change your compare to look at the number rather than the percent.  .9 = 90%:

     

1 Reply

  • The "Percent" copmpare is looking at the portion of the dataset, not the output of the measure.  Change your compare to look at the number rather than the percent.  .9 = 90%: