Forum Discussion
How to display duration in report view
Is there any way to show duration of time in the report (in a table) or data view like I can in the query editor. It seems silly you can format the column in the query editor as a duration but not be able to display it once you apply it. The left is in the query editor, and the right is in data view. Let me know!
thanks
Duration represents a length of time. It’s converted into a Decimal Number Type when loaded into the model. It is as designed according to this document.
If you only want to show duration of time in a Table report. I think the easiest way is to change the Data Type from “Duration” to “Text” as below. Then it will keep the type as "Text" and can be showed correctly.
Best Regards,
Herbert
6 Replies
- Greg_Deckler
Community Champion
This collaborative blog article by konstantinos and myself might help you out:
http://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
v-haibl-msftMicrosoft Employee
Duration represents a length of time. It’s converted into a Decimal Number Type when loaded into the model. It is as designed according to this document.
If you only want to show duration of time in a Table report. I think the easiest way is to change the Data Type from “Duration” to “Text” as below. Then it will keep the type as "Text" and can be showed correctly.
Best Regards,
Herbert
What if you want to create a measure with duration?
Text conversion won't allow a sum, will it?
Thanks
I know this was years ago, but was the solution to keep the duration as text to be able to show on a visual. I have been trying to figure the best approach to display appointment duration and appointment duration over-lap with another appointment.
