Skip to main content

Power BI

Needs Votes

field of "duration" type

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

5185e621 2f97-4f74-9d46-3f9d010102e0 on 05 Jul 2020 23:03:41

RE: field of "duration" type

it will be useful to have this duration. please.

Daniel wu's profile image Profile Picture

d2402e58 65ad-4460-9374-833254573ade on 05 Jul 2020 23:03:01

RE: field of "duration" type

Yes! Time duration please!

Daniel wu's profile image Profile Picture

bc9ae03b e844-4517-81af-82f8d4147f4c 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

f3c196ed 941f-43d8-80c8-d6ee6d7de67c 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

d402c851 cc30-4303-960b-9a6dfc725282 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

99c566f1 96dc-466a-9826-e049d788d344 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

aa6ca821 2f1e-423e-857f-8671c9b3d9ae 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

b43046a5 c63d-4bb7-b879-eaaacebc0ae3 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

7421eae8 a139-4763-a573-1211fc28c839 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

7717f11b 4483-4df8-a6f5-7e2b09d3a762 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