How to fill the blanks in a horizontal time line

Hi all,
I create this dashboard

and, as you can see, dates on the horizontal time line does not show all the same values. I’m wondering if there is a way to “fill the blanks”.

Example: I’m looking for a certain event from 1th March to 31th March, and I would like to see all the 31 days even if my query return data only for some of them.

Is it possible? My first idea was to create a “TimesTable” filled with all the days from now to 12/31/2099 and join them with my query. Does it make sense?

Thanks
Enrico

You can turn on the “Show date gaps” option but this will only work if your gaps are not at the beginning or at the end.

If this doesn’t work for you, then you’ll have to create a Date table like you’re thinking and join it with your query.

1 Like