Skip to main content
Microsoft Idea

Power BI

Under Review

field of "duration" type

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

Power BI User 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

Prateek Raina on 05 Jul 2020 23:22:29

RE: field of "duration" type

Much needed

Daniel wu's profile image Profile Picture

Prateek Raina 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

Rashmi Ravi 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

Clint 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

Joshua Manning 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

Satish on 05 Jul 2020 23:20:55

RE: field of "duration" type

Please add Data type: Duration

Daniel wu's profile image Profile Picture

Chris99 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

mary 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

Daniel wu's profile image Profile Picture

Guillaume Morin on 05 Jul 2020 23:19:09

RE: field of "duration" type

This is preventing us from properly using Power BI for our Dashboard. I will need to stick with other BI until this is properly fixed. I don't understand how this isn't fixed after all this time