Forum Discussion
Sorting Matrix by rows
Hello,
I have a matrix table with 4 rows fully expanded to look like a table. I would like to be able to sort independently the four rows. There is a way? Otherwise someone could suggest my a way to have a visualization like that using the "Table" visual?
Matrix row sorting is from the outside in, from the higher level of the hierarchy to the lower.
Allow your users to "Personalize Visuals" so they can rearrange (and re-sort) the matrix row fields.
7 Replies
Matrix row sorting is from the outside in, from the higher level of the hierarchy to the lower.
Allow your users to "Personalize Visuals" so they can rearrange (and re-sort) the matrix row fields.
Thank you for the suggestion. But there is a way to have instead a Table with the same visual like the matrix that I have shared?
you would need to create individual measures by year. Not really something I would want to recommend.
Hi vincenzosava
Please refer to my solution in the linked post :
https://community.fabric.microsoft.com/t5/Desktop/Sort-by-columns-by-value-in-Matrix-Visual/m-p/4064997#M1289264It uncludes PBIX with the example
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
I'm sorry, but this is not what I need. I need to be able to sort the rows. The rows of the matrix correspond to "entity code", "BVD Id", "entity name" and "country"
Can you show the desired result?
