field of "duration" type
is it possible to add support for "duration" data type in the report view as in Power Query?

140 comments
-
Viktor commented
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)
-
Viktor commented
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
-
Viktor commented
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. -
Olle Hagelin commented
Yes, GA tools winns the competition against BI just to this issue
-
Jamie Reis commented
Please, please do this!
-
Vagelis Georgariou commented
Yeah, something like this would be pretty helpful for trying to switch reporting from pivot tables etc to POWER BI
-
Anonymous commented
I have the same issue , this is very critical for us, can you please provide a solution ?
-
Anonymous commented
I've just tried to upload information into Power BI the hours are in the [h]:mm:ss however it cannot cope with this format and anyone working over 24 hours are now showing incorrectly.
Can you please add this.
-
Robert A. commented
Please add this as an option for Time formatting in Power BI - [h]:mm:ss
I should be able to use this just as I do in Excel.
-
Jorgemenas commented
This is a really essential feature for the Google Analytics pack. I hope they do it soon!
-
Ben commented
Power BI are missing a trick by not having this in! As others say it's really essential for contact centres and Power BI is such a great way of displaying data to teams like this their product dev/sales teams really need to get it sorted.
-
Mauro Giusti commented
Same issue, see here - all you need to test this is a SQL query that returns a TIME type.
https://community.powerbi.com/t5/Desktop/Can-t-use-SQL-TIME-as-Duration/m-p/97180 -
Vino commented
Need to make graph about duration time
-
Lex commented
Can't operate Power BI in a call centre environment without durations!
-
Anonymous commented
We need this to graphically represent times as well as having text durations.
-
Steven Wheeler commented
Power Query has a Duration data type and dedicated functions to analyse durations, but in the Data View for Reports it gets converted to a decimal part of a day - e.g. 20 seconds shows as 0.00:00:20 in Power Query but as 0.000231481 in Reports. And to manipulate it needs convoluted DAX - e.g. http://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
-
Anonymous commented
Conveter (HH:mm) to Duration querying
excel information.
please help me. -
Blair commented
The Google analytics pack has problems as well as average session duration is a data type of duration
-
john.brennan commented
For anywhere that operates a call center, being able to show duration is an absolute must!