Forum Discussion
Sort Matrix by multiple rows
DavidPorTodos You can Sort by multiple Columns in a Table by Simply HOLDING on the "shift" Button while clicking asc or desc on other columns.
But The logic is different with a Matrix table.
Looking at your images, you want to sort by Q1, Q2, Q3, and Q4 per year.
You can archive this by expanding the ROWS, sorting on the quartiles, and then collapsing all the fields once done.
See the attached video.
I hope this meets your needs.
Note: You can also use DAX to make a logic sorting arrangement. I would be happy to help, if you can send a bpix with sample data - it does not have to be the data you are working on, but it is closely related.
If this post helps, please consider Accepting it as the solution to help others find it more quickly.