Zero values not shown in visualization when using set expression

[vkal12]

Dear Community,

I have multiple bar charts where I am showing the days of the current month on the x-axis and caculated values on the y-axis. 

If I am just using Sum(Field) in my calculation the graph is shown as below: 

If I need to use some kind of set expression in my formula it is not showing the 0 values on the x-axis anymore. 

Is there any way I can achieve that all the days of the current month (1-30) are displayed on the x-axis even when using a set expression? 

Thank you very much for your support!

Kind regards, 
Vanessa

[rubenmarin · Accepted solution]

Hi, you can try adding +Sum(0) or +Sum({1} 0) to you expression.

It may need some fixes depending of the chart, table, selections, datamodel... but maybe it works just adding that.

[vkal12]

Hi @rubenmarin,

thank you very much, it's works perfectly! I have just added "+ Sum(0)" to the formula and it works. 

Kind regards,
Vanessa