Howard Ching on 18 Jul 2016 22:06:15
Besides adding support for "duration" data type in the report view as in Power Query:
Being able to convert a number to time duration (e.g. (the number "10" to "240:00:00") and have it as time/duration data type.
Currently it's only possible to convert it to Time (HH:mm:ss), which has a limit of 24 hours. Data on more hours/multiple days is lost.
When using duration as data type, in report view it's still viewed as a number of days (e.g. 1,xx for 24 hours and xx minutes)
Administrator on 19 Jul 2016 03:44:36
Check out Duration.From () : https://msdn.microsoft.com/en-us/library/mt253541.aspx
- Comments (7)
RE: Better Time Duration Support
Still not completed. Check https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8814178-field-of-duration-type
RE: Better Time Duration Support
This is not completed.
The idea refered to have duration format not only on Query Editor, but also in Report Editor.
The thing is that you can put duration format as hh:mm:ss on Query Editor but it transforms to an integer in seconds on Report Editor.
When you work with Service Desk or Call/Contact Center Dashboards it is really necessary to work with duration format.
It will be also neccesary to work with these durations on Y Axis in the graphics.
RE: Better Time Duration Support
Miguel, this is not completed. You didn't read the idea correctly.
RE: Better Time Duration Support
'@Miguel,
You've missed the point of the idea. See https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8814178-field-of-duration-type
RE: Better Time Duration Support
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.
RE: Better Time Duration Support
it's not completed!! there is a misunderstanding.
Actaully PowerQuary has DURATION TYPE support.
POWER PIVOT DOESN 'T.
We desire DURATION TYPE supported in POWERPIVOT
RE: Better Time Duration Support
only works in query mode... in report view values are changed back the data type chosen... and duration is not possible as data type in report view :(