Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to 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
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
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 151 | |
| 130 | |
| 109 | |
| 79 | |
| 54 |