Sorting Rows in Matrix

[HenryJS]

Hi all,

How can I change the order of the 'Subset' column in the below matrix?

It is a text column and has sorted alphabetically by default.

Is it possible to change the order to one I specify? I would like to change them around 

[v-deddai1-msft · Accepted solution]

Hi @HenryJS ,

Not sure how you want to sort, but you can add a new column and use sort by column. For more details, please refer to https://community.powerbi.com/t5/Desktop/How-to-sort-row-headers-in-a-manual-sort-in-matrix/m-p/9460...

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

Best Regards,

Dedmon Dai

[Pragati11]

Hi @HenryJS ,

You can give a ranking to your Subset column like:

Val1 --> 1

Val2 --> 2 .....

Then move this rank column to the matrix tootltip, then sort the matrix in ascending order using this tootltip column under 3 dots.

Thanks,

Pragati