Forum Discussion
Helper VDAX switch and sorting
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?
3 Replies
- Greg_Deckler
Community Champion
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.
jochendecraeneI'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?
- Jidnyasa2904
Helper I
jochendecraene and Greg_Deckler If you found a way around it, please share. I am trying to solve a similar problem.
