Sorting of alphanumeric column in Matrix table

[Anonymous]

Hi Team,

 I am trying to sort alphanumeric column but its not working as expected. 

its appearing as 

1,10,11,12,2,3........I want in numerical order. I tried by spliting numeric part as separate column and sort it but I not working as I need to show text and number as single column.

Please advise if anyone has idea..Really appreciate your help!!

[v-shamiliv]

Hi @Anonymous 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-shamiliv]

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

[govind_021 · Accepted solution]

Hi @Anonymous 
I have created new column from example feature of power query to extract numbers from the column  and
sorting the column used in the martix by new column
may be this can solve issue.
Please refer to the below file
https://github.com/govind-2000/Dax-Questions-/blob/main/example.pbix
Best Regards
Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
Let's Connect
Linkdin - www.linkedin.com/in/govind-sapkade-845104225
Youtube - http://www.youtube.com/@govind_dataanalyst

[v-shamiliv]

Hi @Anonymous 

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.

[techies]

Hi @Anonymous please check this custom column

= Number.FromText(Text.AfterDelimiter([Sprint], "Sprint "))

[Anonymous]

Hi @techies  I have tried this customer column but as soon as I merge this column with word "Sprint" like Sprint 1,Sprint 10..it become text value and sorting goes as before as per text sorting as shown before in matrix table..NO luck yet...

[techies]

Hi @Anonymous yes, pls convert to whole numbers and then sort by this new column

[audreygerred]

Hi! You can create a dim table to hold you're sorting order. Just put your sprints in one column and the sorting order in another. Then join to your table on sprint, but make sure you have sprint from the dim table sorted by the sort order column.

[Anonymous]

@audreygerred   I can create dim tabel but Sprint can be of any numbers so I cant define specific number of sprint in one column.. It shoudl work dynamically for any number of Sprint...Plz advise if it can work for dynamically