Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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!
Alternatively, in the Query Editor, you can duplicate your duration column and change the data type of the duplicate to text.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |