Forum Discussion
markus123
5 years agoFrequent Visitor
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
- jdbuchanan71Super User
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%: