Forum Discussion
Custom Sort by Row in Matrix Table
Hello, I'm trying to custom sort by multiple rows in a matrix table. I have tried adding a switch formula to the dataset and then sorting by that column however it does not work. The only time it works is when I add that field to the matrix. Any help would be greatly appreciated! Thanks
Hi Anonymous
Please correct me if I wrongly understood your question.
You want sort Sales Team by the sort column without putting the sort column in matrix . But the operation is not feasible, because the visual has no conditions to judge how to sort the Sales Team if the column isn’t in Matrix.
So you should put the sort column in Matrix then you can sort the column to effect the Sales Team .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
Hi Anonymous
Please correct me if I wrongly understood your question.
You want sort Sales Team by the sort column without putting the sort column in matrix . But the operation is not feasible, because the visual has no conditions to judge how to sort the Sales Team if the column isn’t in Matrix.
So you should put the sort column in Matrix then you can sort the column to effect the Sales Team .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Did you try that 'Sort by column' on your [Sort] column?
Anonymous - hard to tell without knowing your model. This may sound strange but there was a time when I had a similar error and the only difference in correcting was the direction[field] started from to the [field] ending. Basically I got the error when I pulled from Table1[ColumnB] to Table2[ColumnA] but then I tried Table2[ColumnA] to Table1[ColumnB] and it worked.
