field of "duration" type
is it possible to add support for "duration" data type in the report view as in Power Query?
Jan Bruinenberg commented
Looking from the "user of the report" point of view: you dont want to calculate / transform a digital time (example: 1. 5 to 1:30 (hh:mm) format) .
So a duration format in the report modus form the enduser point of view is in mi opinion a high priority (in the end; they are the persons we developers are working for)
Roque Duarte commented
Any idea as to when this will be sorted out? Seems crazy that this isnt included as yet. Plus it creates lack of depth when trying to pursue KPI generation as one has to do that in an alternate program. Very frustrating
A real duration file type? Thanks a lot
Please get this fixed guys. How is it an option to format as duration in the query editor but can't be used in tabular view??
Gabriel Grünberg commented
This is a bit of a showstopper right now.
Prefered solution from my perspective is to base this on seconds.
ie. you input a whole number or decimal second value and get Power BI gives you options how you want to present it.
Dream scenario would be to have checkboxes for what you want to have as part of the value:
years, months, days, hours, min, seconds, milliseconds.
or just a couple of preconfigured settings:
and so on.
True/Scientific Duration is needed
Example: Decay time 1000 seconds
Example: Cooling time 90 minutes
Example: Weekly opening hours 70:30
Miguel Saldaña commented
Time Series for a Graph
This is an astonishing absence...I'm aghast that this wasn't included within the original spec for PowerBI, and even more so to learn of it's continued absence.
and.... 2 years later.... cmon guys
Raymond John Escobar commented
Please update powerbi to have this feature
Please add a feature to do sum of hours
This is a common thing that most of other reporting tools are having. Please add the duration time as a type and allow to put Avg, Max, Min and the value as such to show in graphs.
Excel allows you to format time using values greater than 24 hours, why isn't this possible in Power BI? even if you use one of the work-arounds, when you export the data, its a text field and you can't sum the values in excel.
A must have. Quite a basic feature. Work arounds ae simply that - work arounds.
When Can it be implemented,as i need to show average call durations
Power BI and Google Analytics should be best friends forever.... and for that, we need a proper format for duration time, with the ability to properly calculate aggregates of duration time. Need. It. Badly.
At least it will be also great if we will be able to set custom axes information in accordance to duration. Bar chart can reflect the data in seconds (as a classic measure), but the data signature/label can be done in duration format (something like mm:ss)
Can someone give us feedback when it will be implemented?
Michael Ros commented
Need duration for reporting on improvement projects with processing and lead times
Please add normal duration behaviour in bar chart. We want to see the Duration on the Y-Axis in HH : MM : SS format.
I need to build infographics on marathon events, and I can't do this properly with PowerBI. Meanwhile Tableau and Qlik provide such possibility.