Forum Discussion
Sorting row or column values in a specific order
Hi, this is a 2-part question. Part #1: I followed a previously published solution: https://community.powerbi.com/t5/Desktop/Sorting-rows-and-columns-in-matrix-visual/m-p/723838#M349347 to try ...
Re. Part #1
I changed the Sort_LOB calculated column to the SWITCH dax, then I selected LOB and sorted by Sort_LOB, and encountered and error message - screenshot attached.
is [Lob] a measure or a Column?
You could also create a new table (Sort_Lob) to do the sorting.
| LOB | Sort_LOB |
| Accounts | 1 |
| Esc Accounts | 2 |
| Billing | 3 |
| Esc billing | 4 |
| Tech | 5 |
| Esc Tech & hardware | 6 |
Then you relate this table to the Employee_Team table you want to sort, and use this Sort_Lob table in the report.