Skip to main content
Microsoft Idea

Power BI

Needs Votes

Matrix - Sort columns by value

Vote (1005) Share
's profile image

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 (71)
's profile image Profile Picture

Alison on 16 Aug 2020 03:53:22

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