Solved: Matrix column date order

Anonymous · ‎12-13-2022

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?

v-jingzhang · ‎12-13-2022

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!

View solution in original post

v-jingzhang · ‎12-13-2022

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!