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)
9 Comments
- Check out Duration.From () : https://msdn.microsoft.com/en-us/library/mt253541.aspx
- 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 :(
- 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
- 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.
- '@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
- Miguel, this is not completed. You didn't read the idea correctly.
- 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.
- Still not completed. Check https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8814178-field-of-duration-type
- Status added:Completed
