Forum Discussion
Sort Date Column ascending in a matrix
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.
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.
Does not work - date is not an option.
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.