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 (69)
RE: Matrix - Sort columns by value
Really need this on the columns to sort Calendar Hierarchy in descending order for some tables.
RE: Matrix - Sort columns by value
Sorting columns in matrices by values is kind of essential.
RE: Matrix - Sort columns by value
Everyone needs this
RE: Matrix - Sort columns by value
It's crazy that this is not available yet!
RE: Matrix - Sort columns by value
It would be awesome to have this functionality!
RE: Matrix - Sort columns by value
Everyone needs this
RE: Matrix - Sort columns by value
We need this functionality.
RE: Matrix - Sort columns by value
we need this
RE: Matrix - Sort columns by value
We have business owners asking for this and declining to move from Excel to PBI (causing us to use this less and less) because this feature is missing.
RE: Matrix - Sort columns by value
Must needed feature. Is there any update on same?