Skip to main content
Microsoft Idea

Power BI

Under Review

field of "duration" type

Vote (1545) 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 (209)
Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 23:25:45

RE: field of "duration" type

honestly embarrassing that this even needs to be an "idea" esp. when the data type's already in Query Editor, PBI for some asinine reasons just decide to ditch the format when it comes to actual making the dashboard

Daniel wu's profile image Profile Picture

James on 05 Jul 2020 23:25:33

RE: field of "duration" type

There is duration format only on Query Editor, not in Report Editor.

The thing is that you can put duration format as hh:mm:ss on Query Editor but it transforms to an integer in seconds on Report Editor.

When you work with Service Desk or Call/Contact Center data it is really necessary to work with duration format.

It will be also neccesary to work with these durations on Y Axis in the graphics.

Daniel wu's profile image Profile Picture

Brandon on 05 Jul 2020 23:25:15

RE: field of "duration" type

Please add duration not just in query editor but in the model itself. Looking to show average session duration! Thanks

Daniel wu's profile image Profile Picture

Jonathan S. on 05 Jul 2020 23:24:54

RE: field of "duration" type

It is frustrating to discover such incaps on PBI, fix ASAP.

Daniel wu's profile image Profile Picture

Geoff R on 05 Jul 2020 23:24:31

RE: field of "duration" type

Please add this to allow Y-axis charting. Many departments that rely on time based reporting such as Average Handle Time, wrap, breaks etc. Could benefit internally from this.

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 23:24:23

RE: field of "duration" type

add some credibility pluh- eze

Daniel wu's profile image Profile Picture

Scott Souders on 05 Jul 2020 23:24:04

RE: field of "duration" type

Please add Data type: Duration

Daniel wu's profile image Profile Picture

Ashley on 05 Jul 2020 23:23:44

RE: field of "duration" type

WHAT. Here I am bashing my head against a wall thinking I'm doing something wrong... nope... Power BI is just really backwards and doesn't have a simple data type like Duration, so I can't easily visualise call durations in our call report... maybe I should've just built this in Excel!

Daniel wu's profile image Profile Picture

Anton on 05 Jul 2020 23:23:25

RE: field of "duration" type

Also missing this feature trying to calculate application usage for users...

Daniel wu's profile image Profile Picture

Julian Andres on 05 Jul 2020 23:23:18

RE: field of "duration" type

Please add Data type: Duration, its very important to have this data type.