Skip to main content
Microsoft Idea

Power BI

Needs Votes

Matrix - Sort columns by value

Vote (999) 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

Maryam Baghi on 24 Apr 2024 08:26:48

RE: Matrix - Sort columns by value

Yes, this helps us a lot

's profile image Profile Picture

Andreu fil on 19 Apr 2024 09:40:48

RE: Matrix - Sort columns by value

Good information, thankssehackear.top

's profile image Profile Picture

elias zafrani on 18 Apr 2024 23:12:18

RE: Matrix - Sort columns by value

ThanksHackear Instagram Hackear WhatsApp Hackear Facebook

's profile image Profile Picture

Matti From Finland on 19 Jan 2024 10:42:38

RE: Matrix - Sort columns by value

in AppSource, the "Zebra Tables 6.6" has this feature, to bad it is not free... and that visual is lacking other good features, like conditionally formatting the color of values for example (as of today at least).

's profile image Profile Picture

G E on 10 Oct 2023 10:57:09

RE: Matrix - Sort columns by value

We really need all matrix columns to be sortable when the values are based on one field, as they are in a table or in a matrix where every column is based on a separate value field. Tables are difficult to work with in other ways (e.g. you'd need to add a measure for every column instead of just one for all columns), so we can't use those.

's profile image Profile Picture

Michael Milirud on 12 May 2023 17:37:09

RE: Matrix - Sort columns by value

This is such a basic gap in this experience I'm surprised it's still not closed.

's profile image Profile Picture

Kiran Kumar N on 03 Mar 2023 08:07:05

RE: Matrix - Sort columns by value

Scheduled Refresh -TimeWe are able to select Time, for example, 9:00AM or 9:30 AM or 10:00 am or 10:30 am and so on for 48 times in a day.However If we can have option to choose 9:15 am and 9:45 am and 10:15 am and 10:45 am, It would have been better. we are fine with 48 times in day.

's profile image Profile Picture

Kiran Kumar N on 03 Mar 2023 07:52:52

RE: Matrix - Sort columns by value

Matrix - Sort columns by valueCould you please make this happen or maybe come up with the new Matrix visual itself?

's profile image Profile Picture

Michelle Guevara on 06 Jan 2023 19:57:12

RE: Matrix - Sort columns by value

It's 2023... is this still not an option?

's profile image Profile Picture

Andrew Ben2 on 23 Feb 2022 02:56:01

RE: Matrix - Sort columns by value

needed when crossfiltering between tables and matrix. matrix provides one vision and the detail is in the tables.