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?

727 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

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

115 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Marco commented  ·   ·  Flag as inappropriate

    In my case, I needed to report time spent on site, so just formatting as text worked to give a visual representation of session duration. This will not work for operations though.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Please update Power BI to include Duration as a data type in the Date/Time category. I can use Power Query to convert individual start and stop times to calculate a duration, but the column can't be manipulated in Power BI to allow calculations such as the total duration from several instances so that it appears in a way that is easy to understand. Right now I've got a report that says things like "total training time = 46209 minutes" and it just isn't intuitive for my readers.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Hi, please add the function of dutation calculation within the tool ([h]:mm and be able to show the times within the reports accordingly! many thanks...

  • 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.

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.