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?

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

119 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • David commented  ·   ·  Flag as inappropriate

    Would be an amazing addition to graph based on duration in minutes/ seconds for tracking performance metrics. Would greatly appreciate it!

  • BW commented  ·   ·  Flag as inappropriate

    Would like better duration / time period calculations periods please. Would also like to be able to easily graph different times based on date.

  • kapil commented  ·   ·  Flag as inappropriate

    Time formatted filed should be used with Sum, Avg function its common use of every one. Please also provide dynamic nature with sum, summarize function from Slicers.
    Regards
    Kapil

  • Dixit Sharma commented  ·   ·  Flag as inappropriate

    Hello Team ,

    Our organization have more than 200 power bi users had an review from almost all of them are looking for Duration Data Type, in a lot of scenarios we wish to see the average of time and other calculations which is very important during Analysis of the Services we work upon.
    It would be way more beneficial if Power Bi has the capability to do that like in Excel .

    Thanks
    Dixit

  • Guy commented  ·   ·  Flag as inappropriate

    Honestly, this is a much needed feature. I shouldn't have to mess around in excel with all it's extra steps to convert time (which is recorded as a decimal in my company) into a duration. As it stands .5 (which for us is a half hour, or 30 minutes) equates to a half day or 12:00:00 hours.

    Please give us some options here.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I actually got Power BI in order to work on call lengths & waiting for call back times in a health setting. Can it be done please?

  • Anonymous commented  ·   ·  Flag as inappropriate

    How is this not being looked at? You cannot use Power BI for any call centre stats unless you convert it to text or use ridiculous decimal points.

  • Ben Taylor commented  ·   ·  Flag as inappropriate

    I just started using Power BI to create a reporting dashboard for business operations data and like others here was shocked to find that there is no out of the box support for a duration data type. It seems obvious that this information would be a frequent requirement for the y-axis on a chart that refers to business intelligence data.

  • Rasmus Ludvigsen commented  ·   ·  Flag as inappropriate

    3,5 years and still nothing but cumbersome workaraounds?!

    Callcenter Data Analysts everywhere! Unite and vote!!! :)

    (And a big "thank you" to those, who have made workarounds.

  • Anonymous commented  ·   ·  Flag as inappropriate

    We definitely need this feature added. Right now the only way we can convert number of minutes to a HH:MM:SS value casts to a TEXT datatype which then fails on a sort as it is not a true numerical value.

  • Anonymous commented  ·   ·  Flag as inappropriate

    What is the point of having the duration type in power query when the data view doesn't support it!!!!!!

    We need duration for our graphs, so please make it available

  • João Carlos commented  ·   ·  Flag as inappropriate

    I need to include a "duration" field in the chart to evaluate the duration of an event over time. I need it for "yesterday". Pls.

  • Chris99 commented  ·   ·  Flag as inappropriate

    C'mon Microsoft. How about an update on this as a Christmas present? It is is pretty fundamental reporting requirement.

← Previous 1 3 4 5 6

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.