cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sabedin
Helper I
Helper I

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

 

duration.jpg

3 REPLIES 3

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)



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Sean
Community Champion
Community Champion

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 Smiley Happy

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! Smiley Happy

MarcelBeug
Community Champion
Community Champion

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

Specializing in Power Query Formula Language (M)

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.