Forum Discussion
Sort Date Column ascending in a matrix
I have a matix week ending periods in the columns. I would like to sort in the descending order to show the latest date first. In the example below, I would like to see 05/09/20 on the left. I have searched this site but I did not see a solution.
Thanks in advance for your help
Ok, Columns are tricky. You'll need to create a reverse index as this article states.
In your date table in Power Query, you'd do this:
- Sort your date table in descending order by date (Newest date at the top)
- Add an index column
- Re-sort the date table in ascending order.
Now sort your date by the index.
Note that will affect all visuals. You may want to create a duplicate date column in your date table for a descending sort, the use that date column in your matrix, and sort it by the Index column, and leave your original date coluimn alone. That will also make filtering on the date column easier as a Sort By affects filtering.
3 Replies
Click on the elipses in the matrix visual then select the Sort By option.
Select it again and the Ascending/Descending options will show up.
Ok, Columns are tricky. You'll need to create a reverse index as this article states.
In your date table in Power Query, you'd do this:
- Sort your date table in descending order by date (Newest date at the top)
- Add an index column
- Re-sort the date table in ascending order.
Now sort your date by the index.
Note that will affect all visuals. You may want to create a duplicate date column in your date table for a descending sort, the use that date column in your matrix, and sort it by the Index column, and leave your original date coluimn alone. That will also make filtering on the date column easier as a Sort By affects filtering.