Forum Discussion
Duration type in tooltip
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
3 Replies
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)
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 :smileyhappy:
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! :smileyhappy:
Alternatively, in the Query Editor, you can duplicate your duration column and change the data type of the duplicate to text.
