Chart to show all horizontal (x) axis values even when there's no data

[DutchArjo]

I have a chart with a time-variable on the horizontal axis which is loaded from the a time/date table (which is loaded independent of any data). I want the horizontal axis show all the values within the time range but the chart is not showing one period because there is no data. Instead of showing a gap, It just ignores this timepoint.

Why, and how can it be corrected? I have enabled "show null-values". As mentioned: the timetable is completely loaded, no period is missing.

[Anil_Babu_Samineni]

For the x-axis do you have the data? If not, that is expected because for the period you want to see there is no data associated from your source. 

[DutchArjo]

Yes, for the x-axis I have the data. Every possible period is in the table.

[Anil_Babu_Samineni]

are you sure that the value in x-axis is not coming? sometimes due to compress objects it may be hidden. Try to use filter pane for that field and select where you see the gap and see if chart is displaying anything to that? 

[DutchArjo]

I was suggested to add a measure to the chart to force the chart to show this month:

=Count({1<DCA_IsoJaarWeek={">=$(=((Year(Today())-2)*100)+week(today()))<=$(=((Year(Today())*100)+week(Today())-1))"}>} Distinct(DCA_Dag))-7

this results in this chart snippet:

So actually, there's no data as shown by this line.

[Anil_Babu_Samineni]

Please share us the sample file to have a look on this.