Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Go to visual cues and write condition there...
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
May be the 20, 24, 25 are non numerical values, I mean text strings!?!
try it like this
if(LEAD_TIME > 0, LightRed(), if(LEAD_TIME = 'XX',RGB(...)))
Try to write conditionn using aggr function also see the attached file
it could be possible that you have accidental a blank there
No they are numeric and its not always the same numbers it changes when the data get reloaded
As I see in the 'In load' column there is data missing in the row 20, 24 and 25...
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)