Skip to main content
Microsoft Idea

Power BI

Under Review

field of "duration" type

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

Vino on 05 Jul 2020 22:34:55

RE: field of "duration" type

Need to make graph about duration time

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 22:33:57

RE: field of "duration" type

We need this to graphically represent times as well as having text durations.

Daniel wu's profile image Profile Picture

Lex on 05 Jul 2020 22:33:57

RE: field of "duration" type

Can't operate Power BI in a call centre environment without durations!

Daniel wu's profile image Profile Picture

Steven Wheeler on 05 Jul 2020 22:32:55

RE: field of "duration" type

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

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 22:19:44

RE: field of "duration" type


Conveter (HH:mm) to Duration querying
excel information.
please help me.

Daniel wu's profile image Profile Picture

Blair Scott on 05 Jul 2020 22:06:54

RE: field of "duration" type

The Google analytics pack has problems as well as average session duration is a data type of duration

Daniel wu's profile image Profile Picture

john.brennan on 05 Jul 2020 22:04:17

RE: field of "duration" type

For anywhere that operates a call center, being able to show duration is an absolute must!