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?

737 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 →

117 comments

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

    Looking from the "user of the report" point of view: you dont want to calculate / transform a digital time (example: 1. 5 to 1:30 (hh:mm) format) .
    So a duration format in the report modus form the enduser point of view is in mi opinion a high priority (in the end; they are the persons we developers are working for)

  • Roque Duarte commented  ·   ·  Flag as inappropriate

    Any idea as to when this will be sorted out? Seems crazy that this isnt included as yet. Plus it creates lack of depth when trying to pursue KPI generation as one has to do that in an alternate program. Very frustrating

  • Brian commented  ·   ·  Flag as inappropriate

    Please get this fixed guys. How is it an option to format as duration in the query editor but can't be used in tabular view??

  • Gabriel Grünberg commented  ·   ·  Flag as inappropriate

    This is a bit of a showstopper right now.

    Prefered solution from my perspective is to base this on seconds.

    ie. you input a whole number or decimal second value and get Power BI gives you options how you want to present it.

    Dream scenario would be to have checkboxes for what you want to have as part of the value:
    years, months, days, hours, min, seconds, milliseconds.

    or just a couple of preconfigured settings:
    d hh:mm:ss
    hh:mm:ss
    and so on.

  • Ola commented  ·   ·  Flag as inappropriate

    True/Scientific Duration is needed

    Example: Decay time 1000 seconds
    Example: Cooling time 90 minutes
    Example: Weekly opening hours 70:30

  • Miguel Saldaña commented  ·   ·  Flag as inappropriate

    Aggregating-Duration-Time

    Display-duration-as-HH-MM-SS-on-Y-axis

    Duration-as-Y-Axis

    Time Series for a Graph

  • RobZ84 commented  ·   ·  Flag as inappropriate

    This is an astonishing absence...I'm aghast that this wasn't included within the original spec for PowerBI, and even more so to learn of it's continued absence.

  • anoop commented  ·   ·  Flag as inappropriate

    This is a common thing that most of other reporting tools are having. Please add the duration time as a type and allow to put Avg, Max, Min and the value as such to show in graphs.

  • Chris commented  ·   ·  Flag as inappropriate

    Excel allows you to format time using values greater than 24 hours, why isn't this possible in Power BI? even if you use one of the work-arounds, when you export the data, its a text field and you can't sum the values in excel.

  • juju commented  ·   ·  Flag as inappropriate

    A must have. Quite a basic feature. Work arounds ae simply that - work arounds.

  • Jay commented  ·   ·  Flag as inappropriate

    When Can it be implemented,as i need to show average call durations

  • Paulien commented  ·   ·  Flag as inappropriate

    Power BI and Google Analytics should be best friends forever.... and for that, we need a proper format for duration time, with the ability to properly calculate aggregates of duration time. Need. It. Badly.

  • Viktor commented  ·   ·  Flag as inappropriate

    At least it will be also great if we will be able to set custom axes information in accordance to duration. Bar chart can reflect the data in seconds (as a classic measure), but the data signature/label can be done in duration format (something like mm:ss)

  • Viktor commented  ·   ·  Flag as inappropriate

    Please add normal duration behaviour in bar chart. We want to see the Duration on the Y-Axis in HH : MM : SS format.
    I need to build infographics on marathon events, and I can't do this properly with PowerBI. Meanwhile Tableau and Qlik provide such possibility.

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.