sorting in matrix

[jcastr02]

I have a matrix visual and I would like to be able to sort the columns (by clicking on column header either ascending or descending)  when I hover over it doesn't do anything any ideas for workarounds?

[v-csrikanth]

Hi @jcastr02 
As highlighted by @danextian @lbendlin , the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resol
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.

Best Regards,
Cheri Srikanth

[jcastr02]

Hello @danextian's approach worked ! thank you and sorry for delay.

[danextian · Accepted solution]

Hi @jcastr02 

If you enable the total column, you will see that the rows are sorted by the value in that column. Hiding it will not change this behaviour. You will need to create a measure that returns different values as the total based on slicer selection from a column in a disconnected table.

Please see the attached sample pbix.

[lbendlin]

not currently possible.  You need to use the "sort a column by another column"  workaround. That is a static decision.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com