Forum Discussion
Time axis: Complete timeline instead of existing data points
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!
CPL,
Firstly, I am unable to reproduce your issue that relative filter doesn't filter visuals. Could you please share dummy data of your table so that I can test?
Secondly, do you use Timeline slicer and built-in slicer? Do you select data range in built-in date slicer, then use the slicer to filter values in Timeline? If so, I am unable to reproduce this issue, please post screenshots.
Thirdly, you would need to create a hour column in your table, then drag the hour and date columns into X-Axis of chart.
Regards,
LydiaHi Lydia,
Thank you very much for your reply - highly appreciated. I attached an example file which shows the problem. https://ufile.io/d1qo5
When show itmes with no data is selected, the slicer does only remove bars from the chart but does not cut the chart / zoom in. When it's not selected, the chart illustrates only the timespan selected in the filter. The problem for me is that, when I zoom down to days or even hours, you have to scroll hours just to get to the relevant data.
Thanks,
Christian
Anonymous Hi Lydia - any advice on this? Many thanks :-)