Power BI

Needs Votes

Matrix - Sort rows by value (asc or desc)

Vote (341)

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)

Comments (32)

TJ Doherty on 05 Jul 2020 22:29:33

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

If you just use values in a matrix, you can sort them. However, once you add column headers (e.g., grade values like 1, 2, 3, etc.) you lose the ability to sort the value columns. We need to be able to do that!

Mike on 05 Jul 2020 22:28:49

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

There are other registered ideas that are almost the same as this one. This uncontrolled idea submitting option is not efficient. I think this is a really important feature but because of the inefficient registration does not get the votes it deserves (now its fragmented).

In my opinion PBI should mimic Excel pivot tables as closely as possible.

Not my text but I agree fully:
I think that Microsoft must spend more time on these basic, fundamentals of reporting / dashboarding. I worry that too often they spend more time chasing cool, "glitzy" functionality, at the expense of the core functionality that other products have

Ralf Marpert on 05 Jul 2020 22:26:47

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

It is possible to sort by columns,
but there seems to be no existing way to sort by values :-(

VERY IMPORTANT TO ESTABLISH

Power BI User on 05 Jul 2020 22:26:02

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

It is very important to be able to sort words like week days, or months for instance. Many thanks !

Ian Slipicevic on 05 Jul 2020 22:22:25

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

Yes, soooooo important, please add this functionality.

Casey on 05 Jul 2020 22:21:14

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

I'd like to be able to define how rows are sorted. From what I can tell it's AtoZ or ZtoA, but I need to be able to define the sort order.

For example, if I'm using a matrix and have text row values, the logical order in which they should be displayed doesn't necessarily match alphabetic order.