Forum Discussion
jcastr02
1 year agoPost Prodigy
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...
- 1 year ago
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.
danextian
1 year agoSuper User
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.