field of "duration" type
is it possible to add support for "duration" data type in the report view as in Power Query?
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.
This is a really essential feature for the Google Analytics pack. I hope they do it soon!
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.
Need to make graph about duration time
Can't operate Power BI in a call centre environment without durations!
We need this to graphically represent times as well as having text durations.
Bob Smith commented
Essential Call Centre and Telesales metric. We cannot roll out Power BI in our org without this
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
Conveter (HH:mm) to Duration querying
please help me.
The Google analytics pack has problems as well as average session duration is a data type of duration
For anywhere that operates a call center, being able to show duration is an absolute must!