Time sorting in text format

[SR1]

Hi,
I have a calculated column in Power BI report that represent time in the following format which is of text datatype.
Column1
4 hrs 20 mins
548 hrs 11 mins
2 hrs 04 mins
34 hrs 22 mins
60 hrs 40 mins
83 hrs 39 mins
I want to visualize it in a table visual in sorted order but sort by column doesn't work.

I want them in sorted order like this:
Column1
2 hrs 04 mins
4 hrs 20 mins
34 hrs 22 mins
60 hrs 40 mins
83 hrs 39 mins
548 hrs 11 mins

Is there any way I could sort this?

Thank you.

[Greg_Deckler]

Are you using a Sort By column where you convert these to:

260

32891

124

2062

3640

5019

?

[SR1]

I am using sort by column in table visualization. And no the values are not getting converted.

This is the dax func I used to find the duration in hrs & mins.

Column =
INT(Query1[DurationInSecs]/ 3600) & " hrs " &
RIGHT("0" & INT((Query1[DurationInSecs] - INT(Query1[DurationInSecs] / 3600) * 3600) / 60), 2)& " mins"

[v-yuezhe-msft]

@SR1,

Click on the column in your table, then sort it by DurationInSecs column. If you still get error message, please post the full error message.


Regards,
Lydia

[SR1]

@v-yuezhe-msft,

This is the error I am getting when I try to sort by DurationInSecs column.

Thanks,

SR

[v-yuezhe-msft]

@SR1,

Could you please share complete data of your table? Regarding to the above error, please review my reply in this similar thread.

Regards,
Lydia