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

c95e1f04 b532-4903-9d27-3a03e2d5c16a on 05 Jul 2020 23:23:18

RE: field of "duration" type

Please add Data type: Duration, its very important to have this data type.

Daniel wu's profile image Profile Picture

439079ec 9ef3-46b0-ac5e-e22b7cb796d4 on 05 Jul 2020 23:22:53

RE: field of "duration" type

There's no way to format a duration field in the report. It just comes as a fixed decimal number, which is useless.
Please solve it!

Daniel wu's profile image Profile Picture

61a9031a 2af9-416f-a107-c232aff387bf on 05 Jul 2020 23:22:29

RE: field of "duration" type

Much needed

Daniel wu's profile image Profile Picture

61a9031a 2af9-416f-a107-c232aff387bf on 05 Jul 2020 23:22:29

RE: field of "duration" type

We should be able to plot time in Y Axis of any chart

Daniel wu's profile image Profile Picture

eb0479a2 ba92-4c63-93ce-aeb82e787837 on 05 Jul 2020 23:21:48

RE: field of "duration" type

Please do provide this feature asap as this is much needed feature on Power BI and there are more number of voters.

Daniel wu's profile image Profile Picture

31af8277 9c12-46a1-87dd-533ec3c1b5ec on 05 Jul 2020 23:21:39

RE: field of "duration" type

A real disappointment this function doesn't exist on PowerBI. Been Battling with this for days now....although we wouldn't be able to show how much time on a visual......

Daniel wu's profile image Profile Picture

a0a59ff5 4ace-48a1-9793-5d97468de23d on 05 Jul 2020 23:21:25

RE: field of "duration" type

I just had to tell a potential customer at our organization's call center that we would not be able to meet his reporting needs because our data analytics platform did not support aggregating call times in visualizations. They were disappointed, to say the least, and so was I. This is a vitally important feature for so many service lines. I urge the Power BI dev team to put this idea on their priority list.

Daniel wu's profile image Profile Picture

09a75ca1 fbd9-4901-859f-0df644c92f15 on 05 Jul 2020 23:20:55

RE: field of "duration" type

Please add Data type: Duration

Daniel wu's profile image Profile Picture

d1be4022 6419-4f85-87cf-9d4a137fa0e5 on 05 Jul 2020 23:20:38

RE: field of "duration" type

Is anyone from the Power BI team going to comment on this? How many of your users have a requirement to plot durations on a chart?

Daniel wu's profile image Profile Picture

f0e1f309 d819-4026-b22b-4908e145cb2f on 05 Jul 2020 23:20:38

RE: field of "duration" type

Now that I've started working on call data I see how much work there is to get it working as it should. But it is doable, so perhaps a quick measure would make it more accessible. This post shows you how: https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486