Forum Discussion
Solved
Need help with sorting alphanumeric values
Hello, I am trying to find a solution to how to sort alphanumeric values in a matrix visual. I have values :R1 R2 R3 R4 R5 R6 R7 R8 R9 R10. These values are coming from a New column (not calculated...
I guess i figured out a way to resolve the problem. By adding zero width space unichar() one can manage to tackle these kind of problem. Also adding space between the alphabet and number helps for numeric values in single digit, like R1 R10 R2 R3 will be sorted as R 1 R 2..... R 9 R10.
In case someone comes up with a more convincing solution please help!
rahuldas_vgm Duplicate your column in Power Query. Do a replace to remove the R with nothing (null). Use this as your Sort By column for your R1-R10 column.
Thank you Greg_Deckler for helping!
The column will not show in query edit as it is a created column referencing a measure.
I am unable to write the dax code in edit query.