Sorting Matrix by rows

[vincenzosava]

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?

[Ritaf1983]

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/4064...

It 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

[vincenzosava]

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"

[Ritaf1983]

Can you show the desired result?

[lbendlin · Accepted solution]

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.

[vincenzosava]

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?

[lbendlin]

you would need to create individual measures by year.  Not really something I would want to recommend.

[vincenzosava]

have you an example or a reference for this?