Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I would like to sort a matrix column date in descending order. I am using the 'date' hierchary 'year
'month'. I have tried playing around with sorting that column by yyyymm, yyyy, mm, etc.
But I can't get the following results
Feb2021 Jan2021 Dec2020 Nov2020 etc....etc.... (12 rolling months)
instead I am getting
Jan2020 Jan2021 Feb2020 Mar2020 etc...
or
Feb2021 Jan2021 Jan2020 Feb2020 etc..
Any help is appreciated
Hello.
You need to sort by column and choose a mounth number collum in your calendar table.
look that website for more information
https://docs.microsoft.com/pt-br/power-bi/create-reports/desktop-sort-by-column
See You
I did that and that sort correctly but I still need to accomplish the 2 year period and in descending order. Example
Feb2021 Jan2021 Dec2020. I can't get Dec2020 come right after Jan2021.
Please check in the Table view whether your data type about the date is in text format, if it is in text format, it will also cause this problem.
Hope it helps.
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
90 | |
84 | |
71 | |
49 |
User | Count |
---|---|
141 | |
121 | |
112 | |
60 | |
58 |