Chart Issue

[#1]

Hi,

I have a bar chart with X axis containing Months and Y axis the sum(Sales).

I have to show the data for all months irrespective of whether the data is present there or not.

I have unchecked suppress zero values as well, but still only some months are showing up.

[anbu1984]

If data is not present in table, then create rows in script.

[#3 · Accepted solution]

I found the solution for the same. We can do it in the chart expression as well.

e.g if(isnull(sum(Sales)),0,sum(Sales))

and under presenttaion Tab, uncheck Suppress 0 values