How do I sort column

nniphadk 

You need to create a custom sort order column for it. 

Please follow the approach suggested here: https://community.fabric.microsoft.com/t5/Desktop/Sorting-Calculated-Column/m-p/3132467

Hi ,

Thanks for the solution tharunkumarRTK  provided and i want to offer some more information for user to refer to.

hello nniphadk , based on your description, you can refer to the following solution.

Sample data 

You can create a measure

Measure = int(MID(MAX('Table'[Age Group]),SEARCH(" ",MAX('Table'[Age Group]),,BLANK())+1,2))

Then put the measure to the filter and sort the measure ascending.

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.