Skip to main content

Power BI

Needs Votes

Matrix - Sort columns by value

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

Kevin Coupal on 16 Aug 2020 04:17:32

RE: Matrix - Sort columns by value

Requested over 3 years ago. Can Microsoft at least tell us if this basic functionality is in the funnel to be implemented?

's profile image Profile Picture

jeff.banyard on 16 Aug 2020 04:17:32

RE: Matrix - Sort columns by value

a matrix with dates as a column - looks really weird when you sort and the dates dont sort properly - this really needs to work - or take the sort option off the columns you cant sort by

's profile image Profile Picture

Power BI User on 16 Aug 2020 04:17:26

RE: Matrix - Sort columns by value

oh man ive been searching how to do this, seems like i need to vote for this, hope this will be added soon

's profile image Profile Picture

Simon Hobman on 16 Aug 2020 04:17:18

RE: Matrix - Sort columns by value

Make my life easy please!

's profile image Profile Picture

Lorenzo on 16 Aug 2020 04:17:00

RE: Matrix - Sort columns by value

Really need this on the columns to sort Calendar Hierarchy in descending order for some tables.

's profile image Profile Picture

GDub on 16 Aug 2020 04:16:44

RE: Matrix - Sort columns by value

Sorting columns in matrices by values is kind of essential.

's profile image Profile Picture

Randall Tupper on 16 Aug 2020 04:16:42

RE: Matrix - Sort columns by value

Everyone needs this

's profile image Profile Picture

Julie on 16 Aug 2020 04:16:38

RE: Matrix - Sort columns by value

It's crazy that this is not available yet!

's profile image Profile Picture

Richa on 16 Aug 2020 04:16:36

RE: Matrix - Sort columns by value

It would be awesome to have this functionality!

's profile image Profile Picture

Gamaliel Dacayo on 16 Aug 2020 04:16:29

RE: Matrix - Sort columns by value

Everyone needs this