Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    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!

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

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!