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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
GD61
Helper III
Helper III

How to sort Months by chronological order?

Hello,

Question of a beginner: I'm trying to do this:

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-sort-by-column/

but with no avail.

What I'm missing?

Thanks for your help

 

My .pbix file is here:

Télécharger

 

2 REPLIES 2
ALeef
Advocate III
Advocate III

Essentially, what you want to do is make another column that is MonthNumber = MONTH(yourdatefield).  That puts a numerical field there corresponding with months of the year 1- 12.  Then click on your date column (or month column however you have it spread out) and look up at the top ribbon for "Sort by" and click your MonthNumber column.

WillT
Community Admin
Community Admin

Hi there. Sorry no-one's responded so far! You've found the right article, the 'Sort By' functionality should help you here. I can't get to the download you posted so not sure exactly what the problem is; if you let us know more details we can help out.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.