Forum Discussion

Beau-Vintertun's avatar
Beau-Vintertun
Frequent Visitor
10 years ago
Solved

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...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    10 years ago

    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

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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

  • rodrigod's avatar
    rodrigod
    New Member
    9 years ago

    What if you want to create a measure with duration?

     

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

     

    Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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