Forum Discussion
Solved
Matrix visual sorting column
Hi all, I have created a Matrix visual which has the datepart Year as column. The year is sorted asc. It is possible to sort it desc? Thanks.
Hi Sebastian,
Based on my test, you should be able to follow steps below to sort Year column desc on Matrix visual.
1. Add a Year column to your table if you don't have it yet.
2. Use the formula below to create a new table, and create a relationship between the new table and your table with the Year column.
Table = SUMMARIZE ( Table1, Table1[Year], "Reverse Year", - MAX ( Table1[Year] ) )
3. Sort "Year" column by "Reverse Year" column in the new created table.
4. Then you should be able to show the Year column from the new created table as Column in the Matrix to Order Yer desc.
Here is the sample pbix file for your reference. :smileyhappy:
Regards
Click the header of the column you will see an Arrow appear on the bottom left. Double clik on the header to change your sort order