Forum Discussion
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 ...
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
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.