Forum Discussion
Matrix column date order
Hi Power-Bi Experts,
When I create a Matrix table and have the column headers as the dates, I know how to sort these into Jan, Feb, March, etc.
But...
How do I sort to show Dec 2022, Nov 2022, Oct 2022, etc, etc.
The table contains dated columns from now (Dec 2022) to Sept 2019 (one month per column)... so I need Dec to show first (on the left) and then every month (in order) as I scroll to the right.
Any ideas?
Hi Anonymous
Add these two columns to your table
Month Year = FORMAT([Date],"mmm yyyy")Year Month Sort = -1 * (YEAR([Date])*100+MONTH([Date]))Then sort "Month Year" column by "Year Month Sort" column. Sort one column by another column in Power BI
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!
1 Reply
Hi Anonymous
Add these two columns to your table
Month Year = FORMAT([Date],"mmm yyyy")Year Month Sort = -1 * (YEAR([Date])*100+MONTH([Date]))Then sort "Month Year" column by "Year Month Sort" column. Sort one column by another column in Power BI
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!