field of "duration" type
is it possible to add support for "duration" data type in the report view as in Power Query?
Scott Allen commented
For all the work put into Time Intelligence functions, the fact that this is missing is unsettling.
please consider the duration type in a future update.
Would be an amazing addition to graph based on duration in minutes/ seconds for tracking performance metrics. Would greatly appreciate it!
Would like better duration / time period calculations periods please. Would also like to be able to easily graph different times based on date.
MS, please consider the duration type in a future update
Time formatted filed should be used with Sum, Avg function its common use of every one. Please also provide dynamic nature with sum, summarize function from Slicers.
Dixit Sharma commented
Hello Team ,
Our organization have more than 200 power bi users had an review from almost all of them are looking for Duration Data Type, in a lot of scenarios we wish to see the average of time and other calculations which is very important during Analysis of the Services we work upon.
It would be way more beneficial if Power Bi has the capability to do that like in Excel .
This is a must have!
Very needed as time duration's are essential in any planning type analysis.
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.
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?
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.
Ben Taylor commented
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.
Jesse Luoma commented
When will HH:MM:SS be available?
Rasmus Ludvigsen commented
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.
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.
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
David Gómez commented
Please... Ir is neccesary. I need it to work with timing data in mm:ss.00 format
João Carlos commented
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.
C'mon Microsoft. How about an update on this as a Christmas present? It is is pretty fundamental reporting requirement.