Sort Problem with Matrix

[woscie]

Dear Friends,

I have created an hierarchical structure based on the post  to categorize employees HR data at multiple level. I used martix to display sum of values at multiple levels:

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-to-display-2-levels-of-Hierarchy...

at level one I have one column year, at level 2 I have 4 columns, at level three I have different number of columns per level 2 columns and rows are employees name.

now when I want to sort values at the level 1 it doesn't work correctly.

How can I sort HR data per columns at multiple levels?

Thanks in advance

[JustSayJoe]

Step 1: In your Matrix, add a field to the row hierarchy (which you will later remove).

Step 2: Change the Matrix to a Table visual.

Step 3: Sort all the columns you wish to sort, and in the order you wish them to be sorted.

Step 4: Delete the field you previously added in Step 1 from the table.

Step 5: Change the Table back to a Matrix visual.

Step 6: Ensure the right fields are back in the Row hierarchy.

This will maintain your multiple sorted fields within your matrix, even when you expand your row hierarchies.

[Anonymous · Accepted solution]

Hi @woscie ,

Thanks for reaching out to our community.

Actually, I quite don't understand what you mean about one column year at level 1, 4columns at level 2. Can you please create some dummy data and display the expected result or give examples of the wrong situation based on the data?

Are you trying to sort the columns of the matrix visual? Below is an example.

If so, unfortunately, this is not supported.

Best Regards,

Stephen Tao

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

[woscie]

Hi Stephen,

Thanks for your attention

Yes I want to sort matrix by different columns when I drilled down and drilled up. 

not supported 😞

It is a useful and basic feature!