145 votesGerhard from Vienna commented
I was trying out a lot and spent maybe 2 hours looking for a solution in DAX and even attempring some workarounds.
Only to find out that you'd finally need a native conversion function, like Evendro above described it:
integer --> time format (default notation hh:mm:ss)
Given you have an integer number of 2456 representing seconds and you would like to display it in time format and the name of the new function is TIMECONVERT
It should work out like that:
Default result: 00:40:56 meaning 40 minutes and 56 seconds.
As with any time format you should be able to format to display any other notation like just mm:ss or dd:hh:mm:ss
As with any native format in PBI we should then also be able to have an y-axis in a diagram displaying values formatted this way and you should also be able to calculate with values in this format.
Example: 00:40:56 - 00:21:01 = 00:19:55 etc.
As, like the many votes you can see here, this is an IMPORTANT and success-critical features, still missing, I'd kindly ask the PBI development team to have a look into it and surprise us with maybe the December 2019 release, already coming with this feature !!! :-)Gerhard from Vienna supported this idea ·