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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Prabha45
Helper III
Helper III

Sort by month

Hello, I need to sort my visual by month in a year. I sorted month name column by month(pic 1 ) which I had used in my visual. I sort the axis in the visual(pic2). But didn't work. It is showing as Jan,Oct,Nov,Dec,Feb,March,......Sep. What am I missing ? TIA


Iimage 1.pngimage 2.png

1 ACCEPTED SOLUTION
Arul
Super User
Super User

@Prabha45 ,

Can you check the datatype of month column? I think the datatype of month column now is text. If you check datatype of month column and change it to whole number, It will work.

Thanks,

Arul

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


View solution in original post

1 REPLY 1
Arul
Super User
Super User

@Prabha45 ,

Can you check the datatype of month column? I think the datatype of month column now is text. If you check datatype of month column and change it to whole number, It will work.

Thanks,

Arul

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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!

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
Top Kudoed Authors