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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

how to sort months properly

The months are sorted properly in the data set but when put in the vizualization it is coming alphabetically 

susanpalliparam_0-1650569915604.png

how can sort the data (months) like jan feb march instead of showing in the image 

 

2 ACCEPTED SOLUTIONS
SpartaBI
Community Champion
Community Champion

You need to create a Month ID column in your table and sort the Month column by that column.
Hopefully you are using a data table but you can also accomplish that without it

Watch this for reference:
https://www.youtube.com/watch?v=NlX7Cp2P0d4

View solution in original post

This is month name, not number. 
Please watch this video
https://www.youtube.com/watch?v=NlX7Cp2P0d4

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

even did a sort in the vizual 

susanpalliparam_1-1650570372883.png

 

SpartaBI
Community Champion
Community Champion

You need to create a Month ID column in your table and sort the Month column by that column.
Hopefully you are using a data table but you can also accomplish that without it

Watch this for reference:
https://www.youtube.com/watch?v=NlX7Cp2P0d4

Anonymous
Not applicable

i have created a month ID column 

susanpalliparam_0-1650570298280.png

and it is sorted well there but not in vizualization 

This is month name, not number. 
Please watch this video
https://www.youtube.com/watch?v=NlX7Cp2P0d4

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors