Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!
Solved! Go to 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
@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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 37 | |
| 33 | |
| 29 | |
| 26 |
| User | Count |
|---|---|
| 134 | |
| 104 | |
| 63 | |
| 60 | |
| 55 |