Forum Discussion
sorting in matrix
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?
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.
4 Replies
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
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.
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
