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)
RE: field of "duration" type
This is actually a *really* common request from my clients, especially Call Centres.
It simply comes down to being able to format Duration as HH:mm:ss and then have the "HH" portion go over 24 hours, e.g., 25:59:59. Add this simple feature and you will open up Power BI to a few more markets.
RE: field of "duration" type
This is actually a feature request by the business all the time.
I really hope this is added soon because not being able to create charts based on durations and actually showing the duration in a proper format is looked as a pretty basic feature and that most competitors have.
Thanks
RE: field of "duration" type
What's the point of having Duration in Query editor and not Report view? What corporate on the planet doesn't want to track call-time data or processing times?
RE: field of "duration" type
this is probably the most important addition that we have been waiting for for AGES.....
RE: field of "duration" type
All I want is to format seconds as hh:mm:ss, e.g. 25:59:59. Is this too much to ask?
RE: field of "duration" type
Any update on when this will be even considered ?
RE: field of "duration" type
Unbelievable omission. Would anyone like to guess what an average elapsed time of 1443279 seconds is? Of course not, it's nonsense.
What is even more bizarre is that when you Edit Query there is a type of Duration.
Is there any comments from MS employees on progress of this feature, as without it Power BI is unsellable to our customers.
RE: field of "duration" type
Lack of Power BI's understanding of hh:mm:ss is killing me. I have to convert time duration to measures but measures DO NOT work in tool tips. So in my table I'm showing 61 secs as 00:01:01. In the tooltip the measures shows a 0? Argghhh!!!!
RE: field of "duration" type
yes yes YES. Several local companies in the billons of dollars range would like to see KPI visuals that plot time quicker and easier. There is a tremendous of historical and trend tracking done by corporate America.
Microsoft please tag this one a must have at some point.
RE: field of "duration" type
...quick add for others who see this thread. You can use the software to plot the same trends using a time to decimal conversion. Convert the time to Military format then divide it up by 60 depending on hours or minutes and you can do a halfway decent KPI plot on the Y axis using the time in decimal format. For example 8:45 PM would be 20:45 military time and 20.75 in decimal. .75= 3/4 hour if I have the right conversion formula based on posts out there