Forum Discussion
Solved
Sorting Alphanumeric in custom order
Hi All, I want Alphanumeric values to be sorted in below format. A99 A98 A95 A92 B87 B83 B72 C72 C67 C63 D57 D55 D45 Alphabets in ascending and numb...
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,
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