Duration type in tooltip

[sabedin]

Hello,

When I put durations in line visuals, the tooltip shows its decimal value (see screenshot). Is there any method to show its value in duration type and not in decimals.

changing the format in Modelling tab does not work.

Thank you

Sabedin

[MattAllington]

Do you mean show it in minutes?  Time is stored as decimal numbers where 1 = 24 hours. How about converting the duration to minutes by dividing by (24 x 60)

[Sean]

Unfortunately there's no Data Type Duration in PBI (although there is in the Query Editor)

You can Vote here if you want this feature added

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8814178-field-of-duration-type

In addition to what @MattAllington said you can also use

DATEDIFF to calculate MIN, HOUR, SECOND

https://msdn.microsoft.com/en-us/library/dn802538.aspx

OR

You can use FORMAT just be aware it converts everything to TEXT

https://msdn.microsoft.com/en-us/library/ee634398.aspx

Column = FORMAT(Table[Duration], "HH:MM:SS" )

so if you have Duration as decimal 0.75 it would be formatted as 21:00:00

Hope this helps!

[MarcelBeug]

Alternatively, in the Query Editor, you can duplicate your duration column and change the data type of the duplicate to text.