Forum Discussion
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 numbers in descending here.
Note: Numbers can be repeated in text.
Thanks in Advance.
Thanks,
Aradhana
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
8 Replies
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 Aradhana,
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.
