Power BI

Needs Votes

Sort by individual column values in a matrix

Vote (165)

VickyD on 13 Nov 2017 21:45:48

If I create say matrix with employees on rows and months on columns with expenses in values, I currently cannot sort by a particular month to see who were the top spenders in that month. I can only sort the totals.

Excel allows sorting on individual column values. Need similar functionality in the matrix as well.

Comments (11)

Comments (11)

Andreu fil on 19 Apr 2024 11:13:34

RE: Sort by individual column values in a matrix

Good information, thankssehackear.top

s F on 21 Aug 2023 13:32:56

RE: Sort by individual column values in a matrix

6 years and no fix for this?

JJ on 10 Jul 2020 17:21:46

RE: Sort by individual column values in a matrix

unfortunately this is still a not resolvable challenge , matrix columns cannot be sorted if you have more then one field on the column axis. hint: zebrabi visual can sort on any column but its not free

Dr. Balaji Krishnan on 06 Jul 2020 00:15:38

RE: Sort by individual column values in a matrix

Yes, this would be a very useful feature.

Gary Thomann on 06 Jul 2020 00:09:53

RE: Sort by individual column values in a matrix

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