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 (70)
RE: Matrix - Sort columns by value
Needed
RE: Matrix - Sort columns by value
This would be really useful!
RE: Matrix - Sort columns by value
This would be really useful!
RE: Matrix - Sort columns by value
Is there any other idea like that opened? What I have is a Matrix that have 3 columns (e.g Year = 2016, 2017 and 2018). The values (measures) below this column can only be sorted by the total sum of the 3 years instead a specific year like 2018 for example.
RE: Matrix - Sort columns by value
Yes this feature is very important, especially if e.g. Column 1: Value 2 which only has blank, it will not be suppressed.
In Excel PowerPivot, by moving Value above Column, the "blank" Value 2 will not be shown under Column 1.
Kindly add this feature asap!
RE: Matrix - Sort columns by value
We need this feauture ASAP. We can now put the values on rows, but still can't decide whether first, in the middle or last, in columns nor rows.
In this topic is a little better explain: http://community.powerbi.com/t5/Desktop/Move-up-values-field-on-column-matrix/m-p/400372
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