How to present zero and null in bar chart

[Rudi]

Hello,

I have a bar chart with the following dimension:  =Monthname(AsOfPeriod)

And the following expression:       =Count({$<Risicocategorie={'midden'},Categorie={'Milieumelding'},
PeriodType={Current},Cal_Year=,Fis_year=,Fis_year2=,Cal_Month=,Cal_MonthYear=,Fis_period=,Date=,
AsOfPeriod={'>=$(=vMaxDate12)<=$(=vMaxDate)'}
>} [Sub categorie])

However I get a bar chart which does not show the zero values (Pls see the attached charts and settings).   What am I doing wrong?

Thx.

Rudi

[lockematthewp]

I would try to check the 'zero on bars' in the presentation tab. if that does not work, try 'show all bars'.

[ramasaisaksoft]

Hi Rudi,

Could you please try to convert the same chart into other format(Straight Table with the help of Fast type change) so that we will know if the chart is showing Null /Zero values then this chart also need to be show. else your data is not correct so check for this conditions data is available or not ?