Gerhard from Vienna

My feedback

  1. 145 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    18 comments  ·  Power BI Ideas » Custom Visuals  ·  Flag idea as inappropriate…  ·  Admin →
    Gerhard 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)
    Example/Requirement:
    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:
    TIMECONVERT (2456)
    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  · 

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.