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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
chillpill
Helper I
Helper I

Sorting by month number not working when trying to show months in correct order

I am attempting to sort this chart by showing the months in the correct order and sorting the Month column by the Month Number method is not working. What am I missing here?

 

Capture.JPGCapture1.JPG

1 ACCEPTED SOLUTION
grantsamborn
Solution Sage
Solution Sage

Hi @chillpill 

It looks like your visual is correct except for the sort order is reversed.  (The sort by MonthNo appears  to be working.)

At the top right corner of the visual, press "...", select "Sort axis" and choose "Sort Ascending".

Let me know if you have any questions.

View solution in original post

5 REPLIES 5
grantsamborn
Solution Sage
Solution Sage

Hi @chillpill 

It looks like your visual is correct except for the sort order is reversed.  (The sort by MonthNo appears  to be working.)

At the top right corner of the visual, press "...", select "Sort axis" and choose "Sort Ascending".

Let me know if you have any questions.

That did it, thank you!

Padycosmos
Solution Sage
Solution Sage

Hope this helps

Padycosmos_0-1677862714958.png

 

This is what I tried in my OP but it's not working so I must be doing something wrong. 

galaamri
Helper I
Helper I

Hi @chillpill 

Sort the column by Month Number. or Create a sepreate calendar table. 

First let's create a calendar table 

Calendar = CALENDAR(FIRSTDATE(table[date]),LASTDATE(table[date]))
then calculated column
Month= FORMAT('Calendar'[Date].[Date],"MMMM")
Year-Month-Code = FORMAT('Calendar'[Date],"YYYYMM")
Last step you would sort Month column by Year-Month-Code.
Please make sure calendar table and data table have a relationship 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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