Forum Discussion
Matrix Sort by Column Header Date Descending
Hi, a68tbird ;
I tested it , product as rows, sales as values, date as column;
If the column is Date Hierarchy, sort by column is not work ,so we should change the different column about year and month.
create a rank column.
Column =RANKX('financials',YEAR('financials'[Date]),,DESC,Dense)The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
a68tbird no, it doesn't show the checkmark but highlights the sorted by column and in your case, it looks ok.
Can you click on the top right corner 3 dots on the matrix visual and make sure the correct column is used for sorting.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
EventDate doesn't show as an option there in the Sort By. I thought that was the whole issue with the "sort by column headers". By default PowerBI sorts the date by ASC, and columns don't appear in the matrix visual sort by options.