Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Sorting of alphanumeric column in Matrix table

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 ...
Need Help
govind_021's avatar
govind_021
Icon for Super User rankSuper User
1 year ago

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