Skip to main content
Microsoft Idea

Power BI

Under Review

field of "duration" type

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

Kim on 05 Jul 2020 23:59:41

RE: field of "duration" type

Indeed; it's kind of weird that this is not supported right now? Please add! :)

Daniel wu's profile image Profile Picture

Ricardo Torrent on 05 Jul 2020 23:59:41

RE: field of "duration" type

much needed!

Daniel wu's profile image Profile Picture

Flynn Williford on 05 Jul 2020 23:58:59

RE: field of "duration" type

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.

Daniel wu's profile image Profile Picture

TP on 05 Jul 2020 23:58:49

RE: field of "duration" type

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"

Daniel wu's profile image Profile Picture

d. nowak on 05 Jul 2020 23:57:23

RE: field of "duration" type

This is a much needed feature that will further improve the versatility of this software. Please consider

Daniel wu's profile image Profile Picture

Antoine on 05 Jul 2020 23:57:17

RE: field of "duration" type

It's a crucial must have. Please solve it

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 23:56:09

RE: field of "duration" type

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

Daniel wu's profile image Profile Picture

Pradeep on 05 Jul 2020 23:55:53

RE: field of "duration" type

I have data stored in format of HH:MM:SS. Not able to show that data on any axis. Kindly consider it.

Daniel wu's profile image Profile Picture

Sandeep Kumar on 05 Jul 2020 23:55:40

RE: field of "duration" type

please consider the duration type in a future update.

Daniel wu's profile image Profile Picture

Dan Figueiredo on 05 Jul 2020 23:55:10

RE: field of "duration" type

This really really needs to be looked at, for anything requiring accuracy you have to have a full view of H:M:S:ms