How to sort by values within a column

[msogge]

Hello,

I am trying to figure out how to allow users an option to sort values in my matrix table by the values themselves, instead of by column. Below is the Matrix I am using:

As can be seen, it is possible to sort "Major" (my rows) alphabetically. However, I'd also like users to be able to sort by % and # (which are measures), largest to smallest. Currently I am unable to do so. When I remove my column ("Year"), it allows me to sort them, but Year a a crucial component of this matrix so I do not want to get rid of it.

Is there a way to allow users to sort by values within a column, similar to how row currently has that sort option?

[v-xinruzhu-msft]

Hi @msogge 

You can sort the visual by the mesaure, click sort by measure, and you can set the sort order :ascending or descending. You can refet to the following picture.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Idrissshatila]

Hello @msogge ,

refer to the following https://youtu.be/EVex9Gv-Hok?si=SaZaJybN0bZMtJmZ