on 11 May 2016 22:35:30
Matrix currently doesn't allow you to sort the columns based on designating values as being a priority above the column field names.
For example, my field in the columns section results in three columns. If you add two sets of values, you are forced to see: Column 1, Value 1, Value 2, Column 2, Value 1, Value 2, etc. Like in a Pivot Table, you should be able to prioritize values so that it shows as: Column 1, Column 2, Column 3, Value 1, Column 1, Column 2, Column 3, Value 2.
- Comments (54)
RE: Matrix - Sort columns by value
I think this should be clarified. The need is to be able to control if values or columns are displayed first in a matrix. Currently you get what is on columns on top with measure below. You should be able to switch that (like you can in Excel) to show measures on top with columns below.
RE: Matrix - Sort columns by value
If you just use values in a matrix, you can sort them. However, once you add column headers (e.g., grade values like 1, 2, 3, etc.) you lose the ability to sort the value columns. We need to be able to do that!
RE: Matrix - Sort columns by value
In fact, vote in both places if you have the votes available. The one noted below has a lot of votes so is more likely to get their attention.
RE: Matrix - Sort columns by value
These are several ideas for this request (all couched a little differently but essentially the same. Please tackle this one. The one with the highest number of votes is in the comment below. PLEASE VOTE for this. https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10948962-matrix-measures-or-values-on-rows-instead-of-colum