How can we improve Power BI?

field of "duration" type

is it possible to add support for "duration" data type in the report view as in Power Query?

554 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Daniel wu shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    92 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Chris99 commented  ·   ·  Flag as inappropriate

        is there any news on this Microsoft? I fail to see how so many years down the line this still hasn't been implemented.

        How can copy and paste features take preference over a fundamental reporting data type?

      • Anonymous commented  ·   ·  Flag as inappropriate

        Hi, i would appriciate to have the time calculation ([h]:mm) function within the Tool and be able to show the times within the reports accordingly! many thanks...

      • Anonymous commented  ·   ·  Flag as inappropriate

        I'm just getting into Power BI and I ran into this issue. I already have the duration calculated in my Excel data source, so all I need the report to show is the value...in hh:mm. How on earth was this not done during the original build?
        What use is a business intelligence tool that can't display time in hh:mm?

      • Anonymous commented  ·   ·  Flag as inappropriate

        This is basic functionality. And its been waiting 3+years for implementation.

        Allow us at least similar make-up option as in Excel - treat the time as integer (for calculating purposes) and apply the time format as some kind of mask in next step.

      • Javi Gonzalez commented  ·   ·  Flag as inappropriate

        Power Query doesn't calculate the duration correctly and the best solution in DAX is to create a "time text" formula, so you cannot sum or do other maths with it. With several duration values in seconds, that usually go over 24hrs (so Time is not an option), this is a must.

      • Troy Prill commented  ·   ·  Flag as inappropriate

        When is this going to happen, Microsoft? You've added it to the Query Editor but not the report field?

      • Jeanne commented  ·   ·  Flag as inappropriate

        A duration data type is badly needed and seems a basic need. I keep running into this. Please fix.

      • Anonymous commented  ·   ·  Flag as inappropriate

        honestly embarrassing that this even needs to be an "idea" esp. when the data type's already in Query Editor, PBI for some asinine reasons just decide to ditch the format when it comes to actual making the dashboard

      • James commented  ·   ·  Flag as inappropriate

        There is duration format only on Query Editor, not in Report Editor.

        The thing is that you can put duration format as hh:mm:ss on Query Editor but it transforms to an integer in seconds on Report Editor.

        When you work with Service Desk or Call/Contact Center data it is really necessary to work with duration format.

        It will be also neccesary to work with these durations on Y Axis in the graphics.

      • Brandon commented  ·   ·  Flag as inappropriate

        Please add duration not just in query editor but in the model itself. Looking to show average session duration! Thanks

      • Anonymous commented  ·   ·  Flag as inappropriate

        Please add this to allow Y-axis charting. Many departments that rely on time based reporting such as Average Handle Time, wrap, breaks etc. Could benefit internally from this.

      • Ashley commented  ·   ·  Flag as inappropriate

        WHAT. Here I am bashing my head against a wall thinking I'm doing something wrong... nope... Power BI is just really backwards and doesn't have a simple data type like Duration, so I can't easily visualise call durations in our call report... maybe I should've just built this in Excel!

      ← Previous 1 3 4 5

      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.