How can we improve Power BI?

← Power BI Ideas

field of "duration" type

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

930 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

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

152 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • 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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I have the same issue , this is very critical for us, can you please provide a solution ?

1 2 3 4 5 7

Power BI Ideas: Desktop

Categories

Feedback and Knowledge Base

(thinking…)

Ready to get started?

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