Skip to main content

Power BI

Needs Votes

Matrix - Sort rows by value (asc or desc)

Vote (341) Share
Daniel Bartley's profile image

Daniel Bartley on 24 Jul 2015 21:24:43

There is currently no customisation for sorting of matrices. Please copy existing Excel functionality to sort by row name or by value fields ascending or descending.

Comments (32)
Daniel Bartley's profile image Profile Picture

Power BI User on 06 Jul 2020 00:12:19

RE: Matrix - Sort rows by value (asc or desc)

Do it already, its been 5 years and counting.

Daniel Bartley's profile image Profile Picture

Gary Thomann on 06 Jul 2020 00:09:53

RE: Matrix - Sort rows by value (asc or desc)

Beef up the Matrix hierarchical sorting functionality as per:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11185431-add-a-multiple-columns-sort-featue 

Daniel Bartley's profile image Profile Picture

James on 06 Jul 2020 00:09:12

RE: Matrix - Sort rows by value (asc or desc)

It might be helpful to have another set of fields available in the visualization properties to define a list of row/column/measure used for sorting. Even better would be a user-configurable way to define multiple levels of sorting.

Daniel Bartley's profile image Profile Picture

Andrea Schlossnikl on 06 Jul 2020 00:07:31

RE: Matrix - Sort rows by value (asc or desc)

Matix sorting is a must! Still waiting for it!

Daniel Bartley's profile image Profile Picture

NTK on 05 Jul 2020 23:48:07

RE: Matrix - Sort rows by value (asc or desc)

Sort out the Sorting soon! nearly 4 years since this idea was posted!

Daniel Bartley's profile image Profile Picture

Joao on 05 Jul 2020 23:30:43

RE: Matrix - Sort rows by value (asc or desc)

We need this.
Its is the basic in Excel that we use so much. Its so frustrating when I need to sort by total sold in 2018 for example, and I have more 3 columns like 2017, 2016 & 2015. It does not allow me to sort by last year, or by 2017 and so on. The sort option is either total columns or in alphabetical order by customer.

Daniel Bartley's profile image Profile Picture

Adrian C on 05 Jul 2020 23:27:46

RE: Matrix - Sort rows by value (asc or desc)

Please add in this feature!

Daniel Bartley's profile image Profile Picture

Jeff Tennis on 05 Jul 2020 23:25:00

RE: Matrix - Sort rows by value (asc or desc)

just discovered this today.....seriously? you cannot sort a matrix high/low by a column value?

Daniel Bartley's profile image Profile Picture

CHIRANJIB MAZUMDAR on 05 Jul 2020 23:22:41

RE: Matrix - Sort rows by value (asc or desc)

We need this, please.

Daniel Bartley's profile image Profile Picture

someone453 on 05 Jul 2020 23:19:14

RE: Matrix - Sort rows by value (asc or desc)

Are you serious that I can't sort e.g. sales figures in ascending/descending order? This is the most basic feature of a table/matrix I can think of! It's comparable to not being able to send texts on my mobile... Please fix this asap!