Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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-msft's avatar
    v-cherch-msft
    Microsoft 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,