Problem with text color of Dimensions

[mmortsie1]

I would like to set the font color of the pivot table if a field has a specific value. And for some reason it does not  work correctly I set the Text color to be different if the LEAD_TIME is > 0 and for some reason the Lead time 20, 24 and 25 do not change. The same is if the LEAD_TIME is XX it should be a Different color. Maybe someone has an idea as to why it does not work correctly

[MK_QSL]

Go to visual cues and write condition there...

[mmortsie1]

The visual cue only work for Expressions. But i want to do it for a Dimension and as you can see in my example it does work but just not correctly

[veidlburkhard]

May be the 20, 24, 25 are non numerical values, I mean text strings!?!

[#5]

try it like this

if(LEAD_TIME > 0, LightRed(), if(LEAD_TIME = 'XX',RGB(...)))

[er_mohit]

Try to write conditionn using aggr function also see the attached file

[#7]

it could be possible that you have accidental a blank there

[mmortsie1]

No they are numeric and its not always the same numbers it changes when the data get reloaded

[veidlburkhard]

As I see in the 'In load' column there is data missing in the row 20, 24 and 25...

[mmortsie1]

I tried it with a aggr function still it does not work correct please see the image

=aggr(if(LEAD_TIME = 'XX', RGB(255,153,0), if(LEAD_TIME > 0, LightRed(), LightBlue())),LEAD_TIME)