Skip to main content

Power BI

Needs Votes

field of "duration" type

Vote (1100) Share
Daniel wu's profile image

Daniel wu on 12 Jul 2015 01:13:50

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

Comments (180)
Daniel wu's profile image Profile Picture

1b034c1c e7bf-4ffb-ac6b-8ff58a1b5c5b on 05 Jul 2020 22:55:46

RE: field of "duration" type

Aggregating-Duration-Time

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

Duration-as-Y-Axis

Time Series for a Graph

Daniel wu's profile image Profile Picture

ff2cfcb3 e14b-4b70-86d7-edc24f5d218c on 05 Jul 2020 22:54:34

RE: field of "duration" type

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.

Daniel wu's profile image Profile Picture

19ffcd69 c175-411c-9b5d-aa6ad85761fc on 05 Jul 2020 22:54:01

RE: field of "duration" type

and.... 2 years later.... cmon guys

Daniel wu's profile image Profile Picture

8b748012 44e0-4253-aad8-8ec62a0a94e9 on 05 Jul 2020 22:53:27

RE: field of "duration" type

Please update powerbi to have this feature

Daniel wu's profile image Profile Picture

7e9e1721 9e79-4a66-852e-2c6934af3d4c on 05 Jul 2020 22:53:01

RE: field of "duration" type

Please add a feature to do sum of hours

Daniel wu's profile image Profile Picture

5a10db98 939d-4ba4-8ef8-958b4e0c5b15 on 05 Jul 2020 22:52:23

RE: field of "duration" type

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.

Daniel wu's profile image Profile Picture

f626f805 c9ad-48e9-98d0-3de143e9483e on 05 Jul 2020 22:52:10

RE: field of "duration" type

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.

Daniel wu's profile image Profile Picture

83d3bba5 3d38-459d-bd8c-c174ff03b5c5 on 05 Jul 2020 22:50:23

RE: field of "duration" type

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

Daniel wu's profile image Profile Picture

81b0dd3f b35f-4b50-957d-9a6c9593ebb3 on 05 Jul 2020 22:49:27

RE: field of "duration" type

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

Daniel wu's profile image Profile Picture

02a92a92 e07e-4387-b277-a0b0638159fc on 05 Jul 2020 22:48:42

RE: field of "duration" type

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.