Bar Chart

[#1]

I am creating a dashboard for Profit and Loss .In my data set, there is not transaction for some month as per attached sample excel sheet. but I still want to show 0 value for those month which does not have any transactions.

Can you please advice.

Thank you.

Harsh

[#2 · Accepted solution]

Hi All

I have worked that one out.

Thanks.

It is only a matter of  Presentation tab-->uptick Suppress Zero Values

[#3]

i thought you wanted to autogenerate missing months as well.... PFA the solution.