web
You’re offline. This is a read only version of the page.
close
Skip to main content

Power BI

Needs Votes

field of "duration" type

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

5d8e7d07 b58c-4fd7-a4f3-f18b3abdd569 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

d78c31e1 1c4a-4d0a-8586-d2ea9d11acac on 05 Jul 2020 23:59:41

RE: field of "duration" type

much needed!

Daniel wu's profile image Profile Picture

919b301d 75b8-477e-bdb4-5bc4656cac69 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

db1f3aef 0daa-406a-9644-7f40bd879ac6 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

5fae3c32 af14-49f5-a07e-d37d4e88daae 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

e98b9f4f f065-43a1-9e10-a87612f70daa 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

c7db0010 a63c-4463-af7f-7ab447fe3c4f 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

0d35556e ac6b-4a61-bc25-3673a59886b2 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

89409cac 3c5f-46e0-bdc4-088e64fe5166 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

c58282a8 dc76-e711-812d-e0071b6aa0e1 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