Forum Discussion
Aradhana
Helper I
1 year agoSorting 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...
- 1 year ago
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
Aradhana
Helper I
1 year agoHi 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
Aradhana
Helper I
1 year agoHi 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