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...
CPL,
What do you mean "when I zoom down to days or even hours, you have to scroll hours just to get to the relevant data. "? In your PBIX file, I note that you only have date type field, you don't have time part in the date field, in the chart, you are only able to drill down to Day unless you add Hour field to X-Axis.
Regards,
Lydia
Hi Lydia,
Thanks. Let me describe in other words. When you look into my file, you see two visuals (one with show items with no data activated and one without) and one slicer.
When I use the slicer, it cuts off relevant parts of the visual where show items with no data is not activated.
However, it does only fade out data in the chart where show items with no data is activated, and not adjust / cut off the timeline. So I cannot use the slicer to zoom into a specific time range. This is especially bothersome if I have granular time data such as time stamps on hour basis across a whole year, as I have to scroll in the visual to get to the point in time I want, instead of using the slicer.
Does this make sense?
Thanks. Let me describe in other words. When you look into my file, you see two visuals (one with show items with no data activated and one without) and one slicer.
When I use the slicer, it cuts off relevant parts of the visual where show items with no data is not activated.
However, it does only fade out data in the chart where show items with no data is activated, and not adjust / cut off the timeline. So I cannot use the slicer to zoom into a specific time range. This is especially bothersome if I have granular time data such as time stamps on hour basis across a whole year, as I have to scroll in the visual to get to the point in time I want, instead of using the slicer.
Does this make sense?