Skip to main content

Power BI

Under Review

field of "duration" type

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

k on 05 Jul 2020 23:46:32

RE: field of "duration" type

This is a must have!

Daniel wu's profile image Profile Picture

Mark on 05 Jul 2020 23:46:01

RE: field of "duration" type

Very needed as time duration's are essential in any planning type analysis.

Daniel wu's profile image Profile Picture

Guy on 05 Jul 2020 23:45:10

RE: field of "duration" type

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.

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 23:43:29

RE: field of "duration" type

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?

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 23:43:10

RE: field of "duration" type

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.

Daniel wu's profile image Profile Picture

Ben Taylor on 05 Jul 2020 23:42:28

RE: field of "duration" type

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.

Daniel wu's profile image Profile Picture

Jesse Luoma on 05 Jul 2020 23:41:30

RE: field of "duration" type

When will HH:MM:SS be available?

Daniel wu's profile image Profile Picture

Rasmus Ludvigsen on 05 Jul 2020 23:41:07

RE: field of "duration" type

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.

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 23:40:01

RE: field of "duration" type

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.

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 23:39:55

RE: field of "duration" type

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