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?

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

    109 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • 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.

      • Kris Gomez commented  ·   ·  Flag as inappropriate

        I agree with all regarding this field. I currently have a custom column showing duration between CreatedDate and ApprovedDate (both are datetime columns), but now would like to aggregate the duration column to show average duration and cannot.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Anonymous commented · December 5, 2018 3:40 AM · Flag as inappropriate
        need Duration calculation on Power BI

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

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