Using time instead of date

[Anonymous]

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 

[v-cherch-msft · Accepted solution]

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,