Forum Discussion
Plot dataset with x-axis dates
Hi niccolo_guazz ,
To get this visualization working properly you need to extract the time to another column making your table look like this:
Then use the Time column on your axis and filter for the last relative day
This should give expected result.
If you want to keep the datetime stamp when you donwload it you need to do a different option:
- Duplicate the date column
- Format with hours format hh:mm
- Use this column on your axis
- Filter for the relative date
Has you can see below both charts are the same:
For the more than one day option they only used the date column with the format of date.
See attach PBIX file.
The last field of the values is the tooltip you can add more fields to the tooltip, in this case add the original date column.
Thanks MFelix .
Do you know how I could show wven the day in the black-box below (in addition to the hour)?
And in general do you know how to modify the aspect of the box?
thank you.
The last field of the values is the tooltip you can add more fields to the tooltip, in this case add the original date column.