Custom Sort by Row in Matrix Table

[Anonymous]

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

[Anonymous · Accepted solution]

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.

[Anonymous]

Hi Chris, I did try that and received the error below

[ChrisMendoza]

@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.

[ChrisMendoza]

Did you try that 'Sort by column' on your [Sort] column?

[Anonymous]

Yes I did but unfortunately it doesn't work

[ChrisMendoza]

Try creating a table with DISTINCT() [Sales Team] where you define the sort then use that [Sales Team] column in your visual after you make the relationship. On that table run the 'Sort by Column'.

SortOrder	Distinct Sales Team
1	West
2	Central
3	East
...	...

[Anonymous]

This is what I'm going for but without showing the sort in matrix