How do I sort column

[nniphadk]

This is a regular table in Power BI desktop. How do I order it so that it can appear like so

Under 21 years old
between 22 and 25 years of age
between 26 and 30 years of age

[tharunkumarRTK · Accepted solution]

@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

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[Anonymous · Accepted solution]

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.

[tharunkumarRTK · Accepted solution]

@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

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun