Question about sorting in Matrix Visual

[EmiliaB_123]

Hi everyone,

I have a matrix in a report and I am a bit irritated by the sorting of the values. I have the total that is somehow already set up as descending, and then the three columns before. I have to send this report to different colleagues from the areas A, B and C. And I would like them to click on the column and then just sort by the highest values the figures related to their area. I also tried clicking ctrl+clicking on the column but this is not working. Is that somehow a restriction to the matrix visual?

Thank you!

[amitchandak · Accepted solution]

@EmiliaB_123 , As of now you can not sort on column values. The best you can do is to create a sort column on column(having values A,b, C) and I doubt that can be based on dynamic values

I discussed if for year desc sort on column

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c