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

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

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 23:54:46

RE: field of "duration" type

Crucially required!

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 23:54:20

RE: field of "duration" type

time calculation part is very essential for every business and in production based business and it is very high priority based so if we can get the Time Intelligence function in power bi then it will also help us to improve our key points of business to understand where we are lacking in production.