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,
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
Hi Aradhana,
I wanted to check if you had the opportunity to review the information provided by miTutorials . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.