Forum Discussion
Blank Values on KPI Card
Hi Anonymous,
The NaN% from where? How are you setting up your information what is the visual you are using.
Regards,
MFelix
Hello,
Sorry for the late response, I'm not sure how I missed it. Thank you for replying and helping! I have a been instructed to show on a KPI visual of sorts the Sum of Fans based on Month Year date. When there is no value I need it to show "na", which I'm able to do just fine. However, I'm using the Card with States by OKViz. I'm showing the variance as percent over target. So obviously when there is a value of na it's trying to convert that to a %, and ends up being NaN%. I'm trying to do some DAX trickery and whenever there is no value for the prior month make it just show "na" and haven't been able to get anywhere.
So, in my screenshot I have the layout of the data, and my settings for the visual as well as a filter on a month where there is no value for the prior month which then shows the issue on the visual. Hope this makes sense.
Thanks in advance!
Hi Anonymous,
Not abble to check how you have the final result in this type of card, not abble to repeat your values.
Can you share some sample data?
Regards,
MFelix