field of "duration" type
is it possible to add support for "duration" data type in the report view as in Power Query?
That would be great to have available this feature in Power BI.
I've seen many requests about this subject.
As far as I know, that request is so far suggested and until now i't's not been applied, I think that maybe can be a technical issue.
Kim M commented
Agreed! It is a lovely duration in Power Query, so why can't it also appear in Power Pivot?! Need duration that includes: days h:mm:ss and some folks also need the ms on the end. Most of my durations exceed 24 hours, so days is a critical component.
Dan Day commented
More than 4 years on and still not implemented
Zsofia Burkus commented
Mark Williams commented
I vote a big yes please to this one :)
Bret Pothier commented
I vote yes please. This would be a very handy addition.
Please add ASAP.
This is a massive missing element in Power BI.
Please bring up Excel's [h]:mm:ss format in Power BI ASAP! It's a pity to miss this feature in such a great tool.
Indeed; it's kind of weird that this is not supported right now? Please add! :)
Ricardo Torrent commented
Flynn Williford commented
Perhaps an easy way to implement this would be to have a duration format for the decimal number data type. The format could assume the decimal number represents a number of seconds and then format accordingly in views while leaving calculation models the same.
This is a feature that is most needed. Have a report where I need to add seconds and minutes. I was able to use the below conversion, but I am having problems adding the values by month. // Duration formatting
// * @konstatinos 1/25/2016
// * Given a number of seconds, returns a format of "hh:mm:ss"
d. nowak commented
This is a much needed feature that will further improve the versatility of this software. Please consider
It's a crucial must have. Please solve it
Please do it, so we can replicate Excel's [h]:mm:ss format in Power BI in a way that it shows duration properly even if duration exceeds 24 hours. Example seconds: 1,147,832; time: 318:50:32
I have data stored in format of HH:MM:SS. Not able to show that data on any axis. Kindly consider it.
Sandeep Kumar commented
please consider the duration type in a future update.
Dan Figueiredo commented
This really really needs to be looked at, for anything requiring accuracy you have to have a full view of H:M:S:ms