Skip to main content

Power BI

Needs Votes

Matrix - Sort rows by value (asc or desc)

Vote (297) 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 (33)
Daniel Bartley's profile image Profile Picture

9049da7c 6de8-42b0-9c8e-54de243c95b9 on 06 Jul 2020 00:15:22

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

Please enable the ability to sort by the 'total' column in a matrix table.

Daniel Bartley's profile image Profile Picture

c08cf777 05b2-43e9-9f80-976b4c3812f9 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

1fac0baf 9610-4152-8bad-924d339565a1 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

a6966d00 35c5-4f4f-b011-1f73ec2a9792 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

2415a788 03a7-4693-8768-7bda3d6a31f9 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

449d1132 f0d3-4600-8a87-9e9c8d37116e 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

e7dd35be 3102-49e5-8016-4827944729a4 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

7311711a 4819-46fc-990a-7418047d86a0 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

75ae7b01 f23b-41a1-a329-02bc1ffe67af 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

d0e83ca4 cf0f-4961-9d44-ea07e5045323 on 05 Jul 2020 23:22:41

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

We need this, please.