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

Dusan on 05 Jul 2020 23:03:01

RE: field of "duration" type

Yes! Time duration please!

Daniel wu's profile image Profile Picture

Elison on 05 Jul 2020 23:02:40

RE: field of "duration" type

We need support to Duration Data Type, please!!

Daniel wu's profile image Profile Picture

Sunil on 05 Jul 2020 23:02:22

RE: field of "duration" type

Hello PerBI Team, amazing job what you've done so far. Can we please have "time duration" on X axis ..so that I can show Sales by every hour in a given day, for example. Thank you.

Daniel wu's profile image Profile Picture

Jan Bruinenberg on 05 Jul 2020 22:59:20

RE: field of "duration" type

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)

Daniel wu's profile image Profile Picture

Roque Duarte on 05 Jul 2020 22:58:28

RE: field of "duration" type

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

Daniel wu's profile image Profile Picture

JP Alvarez on 05 Jul 2020 22:58:09

RE: field of "duration" type

A real duration file type? Thanks a lot

Daniel wu's profile image Profile Picture

Brian on 05 Jul 2020 22:56:26

RE: field of "duration" type

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??

Daniel wu's profile image Profile Picture

Gabriel Grünberg on 05 Jul 2020 22:56:21

RE: field of "duration" type

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:
d hh:mm:ss
hh:mm:ss
and so on.

Daniel wu's profile image Profile Picture

Ola on 05 Jul 2020 22:56:07

RE: field of "duration" type

True/Scientific Duration is needed

Example: Decay time 1000 seconds
Example: Cooling time 90 minutes
Example: Weekly opening hours 70:30

Daniel wu's profile image Profile Picture

Miguel Saldaña on 05 Jul 2020 22:55:46

RE: field of "duration" type

Aggregating-Duration-Time

Display-duration-as-HH-MM-SS-on-Y-axis

Duration-as-Y-Axis

Time Series for a Graph