Forum Discussion
Time axis: Complete timeline instead of existing data points
Hi All, When working with time & date data (e.g., date as x axis in a column chart), dates which do not exist in the data set are skipped. Let's say I look at retail revenues (store is close...
My question has changed a bit - I found that I can select "Show items with no data" which gives me the effect I was looking for.
Problem now is, that filters and slicers can not limit the timeline in the visual e.g. if I do a relative filter only for the next 30 days (future), I still see the past in the visual.
Also, when trying to zoom into the timeline with a slicer, the timeline doesn't move although I select only a specific date range in the slicer.
Anyone knows a solution?
Many thanks,
Christian
And one follow-up... has any one managed to get the show items with no data function running on a hourly basis? Seems only to work in the given date hierarchy formats down to days. Thanks!