Skip to main content
Microsoft Idea

Power BI

Under Review

field of "duration" type

Vote (1543) 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 (208)
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

Daniel wu's profile image Profile Picture

David Gómez on 05 Jul 2020 23:39:38

RE: field of "duration" type

Please... Ir is neccesary. I need it to work with timing data in mm:ss.00 format

Daniel wu's profile image Profile Picture

João Carlos on 05 Jul 2020 23:37:57

RE: field of "duration" type

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.

Daniel wu's profile image Profile Picture

Chris99 on 05 Jul 2020 23:37:48

RE: field of "duration" type

C'mon Microsoft. How about an update on this as a Christmas present? It is is pretty fundamental reporting requirement.