cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors