I have a Pivot Table chart in my dashboard that displays the customer ratio by age group and gender. If there is no value belonging to a category, it is currently displayed as a blank cell. Is there a way to fill this part with 0 instead of a blank cell?
I tried to More Formatting Option >> Null Values >> Show Custom, but it wasn’t work at all.
Is there any solutions?
Hi @joohyery
You can use a custom calculated field to show for now
ifelse(isNull(value1),0,value1)
The Null Values in format data is not working for me too.
Hi @joohyery,
It’s been a while since we last heard from you on this thread, did you have any additional questions regarding your post or did the solution provided help with your case?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you
