Skip to main content
Microsoft Idea

Power BI

Under Review

field of "duration" type

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

Viktor on 05 Jul 2020 23:11:18

RE: field of "duration" type

Help us, Please!

Daniel wu's profile image Profile Picture

Rob Sims on 05 Jul 2020 23:09:52

RE: field of "duration" type

I'm producing production planning outputs, got to have a duration based Y axis, especially as there is an easy way to convert data to duration!!

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 23:09:11

RE: field of "duration" type

need visualization of sales as they relate to the duration of marketing campaign(s)

Daniel wu's profile image Profile Picture

Ramadhianto Agung Wibowo on 05 Jul 2020 23:08:43

RE: field of "duration" type

We are monitoring SLA performances on daily basis, so duration on Y axis is needed

Daniel wu's profile image Profile Picture

Muki on 05 Jul 2020 23:08:00

RE: field of "duration" type

what's the status here? is there a workaround for this pls? I have duration in d.hh:mm:ss in my query editor but can't use this data in my reports? have to make a sum of this data in my reports...

Daniel wu's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:06:33

RE: field of "duration" type


support for mm:ss on chart Y axis is a must! please!

Daniel wu's profile image Profile Picture

James on 05 Jul 2020 23:06:09

RE: field of "duration" type

This type of field is really necessary for cases such as Call Center and Help Desks and Service Desks to deal with duration of calls and attentions, many times it is necessary to work with average and more calculations, for which you have to extend fields and use a lot of extra for this.

And even if you set the field as duration in the Query Editor window, it is useless when you try to use it in the Reports Window

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 23:05:52

RE: field of "duration" type

Power Bi team, this kind of data type is a must have for telehealth call centres... my bosses would like to have an average of this in 00:00:00 format. And in addition to this, they would like to have conditional formatting as well to spot call handling time that is above the threshold. it would be really useful having this as a data type and can be conditonally formatted with colors.

Daniel wu's profile image Profile Picture

Power BI User on 05 Jul 2020 23:04:36

RE: field of "duration" type

The same is working in excel, but not in powerbi.Need this future

Daniel wu's profile image Profile Picture

Krishna on 05 Jul 2020 23:03:41

RE: field of "duration" type

it will be useful to have this duration. please.