Forum Discussion
Solved
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 workaround...
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.
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