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

45cdf585 cb97-48a5-b02f-e7aa187e4ed8 on 05 Jul 2020 23:26:00

RE: field of "duration" type

A duration data type is badly needed and seems a basic need. I keep running into this. Please fix.

Daniel wu's profile image Profile Picture

a69570e3 eacd-48ae-bdda-5f044853f7bf 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

72cc1d3f be96-4a0d-8e98-3bfc54790472 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

caf46d12 364c-4a04-bfe8-5ef6f1e5183b 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

fc53de08 476c-4d69-b400-eba7d88d1188 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

f1608323 7b02-4479-89fe-f2cee72b88cc 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

f44f5316 71e9-45dc-9927-940d539b211b on 05 Jul 2020 23:24:23

RE: field of "duration" type

add some credibility pluh- eze

Daniel wu's profile image Profile Picture

8870245b c3ea-e911-a812-000d3a4f1ebb on 05 Jul 2020 23:24:04

RE: field of "duration" type

Please add Data type: Duration

Daniel wu's profile image Profile Picture

5c471b36 f73a-499e-b22c-b761b12d2bc9 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

c5e948b7 aec4-4029-b7fb-2134afe12ca1 on 05 Jul 2020 23:23:25

RE: field of "duration" type

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