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 (73)
RE: Matrix - Sort columns by value
A recent user of Power BI ( previously extensive PowerPivot user) and could not believe that this basic functionality was not there. Please add it soon.
RE: Matrix - Sort columns by value
This idea would make the calculation groups even more useful. Calculation groups could then be used to let the user control which measurs/calculation items to show in matrix visual-columns (through a slicer). However, as long as the user cannot choose which of the measures/calculation items to sort the table by, unfortunately the value in many cases becomes quite limited.
RE: Matrix - Sort columns by value
Such a basic feature not supported?? It is supported in Excel PivotTable. Also, this idea is 3 years old; surprised to see it hasn't got thousands of votes !
RE: Matrix - Sort columns by value
It would be a great addition to the Matrix functionality
RE: Matrix - Sort columns by value
Much needed and also the option to custom sort using a field would be very helpful!
RE: Matrix - Sort columns by value
It is comical that this is not supported. I could not believe when I googled how to do this that it led me to an idea instead of a solution. If I have a column of month names I have no way of sorting the month names into the proper order. I have noticed that Power BI has a habit of not completing basic functionality while adding bells and whistles in their monthly updates. I think Power BI needs to focus on getting core elements completed first and then build on top of that in order to add their flashy features.
RE: Matrix - Sort columns by value
superr neeeded!
RE: Matrix - Sort columns by value
Required the sort feature on column level data.
I have the application data in row wise and environment data in columns,however we dont have the sort functionality on column wise
RE: Matrix - Sort columns by value
Highly Support this idea !
RE: Matrix - Sort columns by value
Need a sort rows feature for matrix, please