Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
80 | |
74 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |