Skip to main content
Microsoft Idea

Power BI

Under Review

field of "duration" type

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

Nick Dell on 24 Oct 2023 15:20:39

RE: field of "duration" type

This is critical requirement in so many use cases, I can not believe we don't have a solution for this. In QlikSense/QlikView this functionality has been around for 10+ years. Any type of productivity reporting or contact center, turnaround time reporting would use this. Our end users do not want to see decimal representing portion of a day, or seconds in the y axis. h:nn:ss please. Any updates Microsoft??

Daniel wu's profile image Profile Picture

Fernando Diego Sobral on 12 Oct 2023 11:34:18

RE: field of "duration" type

When will this feature (really basic feature) be improved?

Daniel wu's profile image Profile Picture

Amaury Van Espen on 09 Jun 2023 09:31:26

RE: field of "duration" type

Is there a simple workaround to summarize duration, for example to get an average duration to use as an axis in a graph ?

Daniel wu's profile image Profile Picture

AsishMurali Muralidas on 16 Dec 2022 13:19:46

RE: field of "duration" type

Please consider implementing this requirement, as this is widely required for many reports.

Daniel wu's profile image Profile Picture

Sandy Anderson on 12 Sep 2022 07:58:33

RE: field of "duration" type

Please consider implementing this into Power BI - it's obviously really needed out there. Time calculations are very common across businesses worldwide.

Daniel wu's profile image Profile Picture

Avik Mukherjee on 17 Feb 2022 10:30:36

RE: field of "duration" type

How many up vote is really needed here for developer/MS to work on this please?

Does it even really require [IDEA] / [UP VOTE] etc. for such basic requirement?

This is one of the simplest requirement in a reporting tool that we should be able to have Duration / Time as Y axis. How else otherwise you can show a multi line chart of expected time of materials arrival vs actual arrival time.


Converting to integer? Really that's worse than saying there is no solution. Because if 1458 and 1459 sit next to each other and 1500 stands miles away (because integer gap is 41 where as in reality Minute gap is just 1) then the whole purpose of charting is distorted.

Daniel wu's profile image Profile Picture

Andrew Jory on 15 Feb 2022 22:16:54

RE: field of "duration" type

I work for SA Health in Australia and we have moved into Power Bi - some people still like Tableau but I'd prefer PBi, please MS work to getting this set. For example I want to be able to plot time periods in either/or X + Y.. I can currently turn time into hour and work with a 24 hour day, and I can manipulate a work around for this, but it could be much easier to show time in a hh:mm format within the charts.

Many thanks for your hard work.


Regards

Clin Epi

Daniel wu's profile image Profile Picture

Vincenzo Turi on 11 Oct 2021 15:19:22

RE: field of "duration" type

any news??

Daniel wu's profile image Profile Picture

Lukas Jarmolowski on 11 Oct 2021 09:07:25

RE: field of "duration" type

How long has it been under review...

Daniel wu's profile image Profile Picture

Albert Martinez on 03 Aug 2021 14:33:26

RE: field of "duration" type

Wow... 5 years of upvoting and nothing. Does Microsoft even look at ideas.powerbi.com 



Killing me smalls.