Forum Discussion
Sorting Alphanumeric in custom order
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
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
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
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
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