Display "0" value in chart

[Anonymous]

Hi,

I have a clustered column chart that display monthly data, however some data are not yet being input. I'd like those empty month to show the value 0. Something like this :

Is there any solution to this? 

[arvindsingh802 · Accepted solution]

You have to define that in your measure, considering you are taking sum in columnA and want to show 0 when its blank
Measure = IF(ISBLANK(Sum(columnA)), 0, Sum(columnA))

If this post helps, then please consider Accept it as the solution and give it a thumbs up