How to hide data for Days = 0

[kaushi2020]

I am using a Master Calendar for my data model. Data for one set of Load don't have data Post 12th.

But the other has data till 20th. 

Due to this I am able to see 0 for the days where there is no Data.

how I can make the view dynamic across sheets.

below is the image where i don't have data post 12th.

Below is the one where I have Data till 20th.

How I can control the Bar chart where I don't have data Post 12 so that it don't show chart where the data is null.

[L_Hop · Accepted solution]

Hi Kaushi2020 ,

In bar chart "data handling" section, there is "include zero values" option, untick that option, probably this will help.

May be  in dimensions section, you may also untick the "include zero values" option.

regards.