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.
75 Comments
- 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
- 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.
- 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!
- 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.
- 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
- 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!
- 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.
- This would be really useful!
- This would be really useful!
- Needed
