Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Step927
Regular Visitor

Order Matrix Month-Year in ascending order

 

Dear Community,


I'm having trouble sorting a Matrix  in ascending order by  Month-year (Jan 2013- text format) that takes the last 13 months based on the date picker . Do you have any solution? Many Thanks

 

1 ACCEPTED SOLUTION
reidnmorrison
Resolver II
Resolver II

To sort the months you can add a custom column to the 'Calendar table' in Power Query that will allow you to sort the [Month_Year_Short] column:

 

Text.From([Year]) & Text.PadStart(Text.From([Month_No]), 2, "0")

 

 

If you are needing to create a measure to dynamically look back 13 months I would suggest watching this video. It can be modified to 13 months https://www.youtube.com/watch?v=d8Rm7dwM6gc

View solution in original post

3 REPLIES 3
reidnmorrison
Resolver II
Resolver II

To sort the months you can add a custom column to the 'Calendar table' in Power Query that will allow you to sort the [Month_Year_Short] column:

 

Text.From([Year]) & Text.PadStart(Text.From([Month_No]), 2, "0")

 

 

If you are needing to create a measure to dynamically look back 13 months I would suggest watching this video. It can be modified to 13 months https://www.youtube.com/watch?v=d8Rm7dwM6gc

reidnmorrison
Resolver II
Resolver II

Do you have a Calander or Dates table in your model. If so what columns do you have in it?

 

 

Hi, below a screenshot of the model.

In the matrix I use the "Month-Year-Short" field in the Calendar Table.
In the date filter I use the date key field from the Tine-Dim
Model.png

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.