How to display duration in report view

[Beau-Vintertun]

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

[NicholeWinterES]

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.

[v-haibl-msft · Accepted solution]

@Beau-Vintertun

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

[sanjeewauom]

But then how you sort in ascending or descending order once converted to text.

[rodrigod]

What if you want to create a measure with duration?

Text conversion won't allow a sum, will it?

Thanks

[Beau-Vintertun]

@v-haibl-msft

Thank you!!

[Greg_Deckler]

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