Forum Discussion
Set KPI to grey when blank returned
Dears,
I have some KPIs in a rapport.
They are only relevant when I apply some filters. I returned "blank" for the current value and target value if it's not relevant.
However my KPI goes green (Good) and returns a NaN as pourcentage, blank as current value (thoses are expected, my measure works).
How can I set my KPI to grey when it's unrelevant?
I see that there is a Color for "None" but I don't know what's a NONE value. And how to get it with DAX.
Thanks for your help
3 Replies
Hi ITandBI,
>>However my KPI goes green (Good) and returns a NaN as pourcentage, blank as current value (thoses are expected, my measure works).
If you mean kpi visual ,you can setting to kpi mode to 'high is good', then seeting bad color to grey.
>>And how to get it with DAX.
Dax formula not support color coding or change visual properties.
In my opinion, conditional formatting seems works for your scenario, but it only works on table and matrix visual at present.
Conditional formatting in tables
Regards,
Xiaoxin Sheng
Yes I know, but I wanted to know if somebody has a solution when I have a "Blank" value for my KPI?
I want to change the color for that case instead of having a green color, having a grey
I saw this value "None", can't I use it for my "blank" case?HI ITandBI,
It seems like you are using a third party custom visual, I'd like to suggest you contact to author for better support.
Regards,
Xiaoxin Sheng
