DAX switch and sorting

[jochendecraene]

Hi

I use a sitch function to calculate categories. Now, when presenting the data in a matrix, the categories are nog properly sorting (column "Switch"). I solved this by adding a letter in front of the categories (Switch B"). 

Is there a better way to solve this?

[Jidnyasa2904]

@jochendecraene and @Greg_Deckler If you found a way around it, please share. I am trying to solve a similar problem. 

[Greg_Deckler]

@jochendecraene Yes, try adding a Sort By column. This generally works best in Power Query. You create the new column with the desired alphanumeric sorting data and then set this column to be the Sort By column of the original column.

[jochendecraene]

I've created a new column, but where/how can I set the sorting based on that new column, since the new column is not a part of my matrix?