Power BI

Needs Votes

Sort in Matrix Visual, just like any column can be sorted in the visual in a Table.

Vote (91)

Raj Kaur on 30 May 2020 01:18:10

Comments (6)

Comments (6)

Ed Hage on 20 Jan 2023 02:54:38

RE: Sort in Matrix Visual, just like any column can be sorted in the visual in a Table.

Multi-column sort for Matrix should have been deployed when Table visual was updated.There's a lot of similar ideas floating around but they have not been consolidated, so the votes are understated here.

Ribeiro Silva on 13 Sep 2022 13:04:38

RE: Sort in Matrix Visual, just like any column can be sorted in the visual in a Table.

Sorting in a table is good. But when I change back to matrix it looses the sorting order of the table.It's enough to correct the transition from table to matrix.I tested with a matrix. I want to sort by 2 rows and then by a value (measure). I changed to table, sorted like I want, and then I changed back to matrix.

Paul Bailey on 29 Jun 2022 16:21:05

RE: Sort in Matrix Visual, just like any column can be sorted in the visual in a Table.

This seems very common sense. I want to group data in a matrix and then sort by a ranking within those groups. Why is this not possible?

Michelle Thomas on 30 Mar 2022 16:24:01

RE: Sort in Matrix Visual, just like any column can be sorted in the visual in a Table.

I need to be able to sort on multiple columns in a matrix the way I can in a table. I Hope they add this like you have said.

Tom Firth on 16 Jun 2021 12:40:28

RE: Sort in Matrix Visual, just like any column can be sorted in the visual in a Table.

Glad you raised this Raj. As Josef said above this functionality is much needed for numerical reporting. Having the ability to sort by the column header has been asked for numerous times by product teams. "More Options" menu gets my thumbs up too.

Josef Künzli on 30 Dec 2020 10:42:47

RE: Sort in Matrix Visual, just like any column can be sorted in the visual in a Table.

That´s a great idea. Currently, a Matrix only allows to sort by Row Header or by the values. It does not allow to sort by Column Header. But that´s a functionality much needed for Finance Reporting. That´s a quick win to fix. You could do it simply via the "More Options" menu within the Visual.
Thanks for considering.