Forum Discussion
Sorting of alphanumeric column in Matrix table
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
Super UserHi Anonymous please check this custom column
= Number.FromText(Text.AfterDelimiter([Sprint], "Sprint "))
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