Forum Discussion
Using time instead of date
Hi all
I am struggling with the following problem
I have 2 date columns (start, end) from which I calculate the time elapsed. I have already formatted it as "time" and not date in the table.
However, when I m using it for charts (i.e. a scatter to show sales vs time spent on task), PBI keeps considering it a date.
When trying to use it as a slicer (to remove outliers) it again considers it a date (i get values from 30/12/1899 to 02/01/1902).
Any idea how to fix this?
Many thanks
Hi Anonymous
Please make sure you've formatted time spent column as below.Then i would suggest you use list or dropdown options of the slicer.
Regards,
1 Reply
- v-cherch-msftMicrosoft Employee
Hi Anonymous
Please make sure you've formatted time spent column as below.Then i would suggest you use list or dropdown options of the slicer.
Regards,