cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
caito103
Helper I
Helper I

Sorting by Month name using month number doesnt work

Hello!

 

I need hel from you guys. I actually searched abput sort correctly by Month name, creating a Month nummber column and sort the column Month name by Month number, but didt work.

 

 

I have this date column, that have data starting in june 2017 until february 2018:

 

 

I created the following columns by the column with the dates, and the Mes (month) column i selected Sort by Column MesNum(MOnthNumber) in Modeling:

 

 

But when i tried to use it in a graph, is not appearing order it. I tried in the axis with Month, MonthNum and MonthNum Hierarchy:

 

 

What can i do? Im need your experience.

 

Thank you!!

1 ACCEPTED SOLUTION
dramus
Responsive Resident
Responsive Resident

MesNum is defined as Text. Switch it to Whole Number and that will fix the sort.

View solution in original post

8 REPLIES 8
dramus
Responsive Resident
Responsive Resident

By default it's going to sort it alpha-numerically.

 

You will need to set the "Sort By" column for the Month column to be the numeric month column.

 

sort_by.PNG

 

 

I did it, but stll not working, im sorting by the numeric month column.

8QMSxT0WTPCCQpFE2WgfKw

 

 

 

dramus
Responsive Resident
Responsive Resident

Check what the sort by on the visual is:

 

sort_by.PNG

its sort by Month (name) too

 

SRTOBVMBQOyPhH91feVdlQ

dramus
Responsive Resident
Responsive Resident

I can't reproduce the problem you are having with a demo dataset. Can you share your .PBIX file with me?

Of course! There you go.

 

https://ufile.io/ovfpu

 

Can be that the month order have problem because there are two years with differents months? (2017 have from June until December, and 2018 just have January/February)

 

Thank you so much!

dramus
Responsive Resident
Responsive Resident

MesNum is defined as Text. Switch it to Whole Number and that will fix the sort.

View solution in original post

Oh man! Was so simple! With it takes a lot haha, thank you so much!!!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.