Sorting Alphanumeric in custom order

[Aradhana]

Hi All,

I want Alphanumeric values to be sorted in below format.

A99

A98

A95

A92

B87

B83

B72

C72

C67

C63

D57

D55

D45

Alphabets in ascending and numbers in descending here. 

Note: Numbers can be repeated in text.

Thanks in Advance.

Thanks,

Aradhana

[v-saisrao-msft]

Hi @Aradhana,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[miTutorials · Accepted solution]

You will have to add a calculated column to define the sort order and then sort the field.. Take a look at the below video.

How to Custom Sort Multiple Columns in Power BI | MiTutorials

[Aradhana]

Hi miTutorials,

I checked your video, means I need to create the new table with alphanumeruc field and id(say 1,,2,3,4..) field manually and sort the alphanumeric field by id field?

Please correct me If I'm wrong.

Thanks,

Aradhana

[v-saisrao-msft]

Hi @Aradhana,
I wanted to check if you had the opportunity to review the information provided by @miTutorials . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[miTutorials]

If you have a lot of rows then it's good to create a table, merge and then sort else simply create a calculated column to return the sort order. See below video on how to create the calculated column.

How to Custom Sort in Power BI | MiTutorials | #powerbi #PowerBITutorial - YouTube

[Aradhana]

Hi miTutorials,

Your solution works only If there are fixed values. What if new data arrives in data model? then how fixed sorting order will work?

Thanks,

Aradhana

[Aradhana]

Hi @miTutorials

Your solution works only If there are fixed values. What if new data arrives in data model? then how fixed sorting order will work?

Thanks,

Aradhana

[meechielvp60]

OK