Displaying only the time of Data and Time

[Anonymous]

Hi All,

I am trying to calculate the time difference between the max time and min time of the entries in an ID.

How do I change the column in the visual so that the date doesnt display, only the time?

e.g. the second row, third column, would just say 08:37:00

Thanks in advance for the help

[Anonymous · Accepted solution]

One way is go to edit query select column and right click on it. 

Edit query -->Select datetime column --> Right click --> select transform --> select Time Only

[MFelix]

Hi  @Anonymous ,

It's possible in PBI to use custom format strings for columns or measures on the modeling view check the documentation if you are using a column or a measure and don't want to change the format becayse you can use it in other visual in a different way you can create an additional measure or column with the FORMAT sintax something similar to this:

Hour Format = FORMAT(Table[Column]; "hh:mm:ss")

Regards,

MFelix