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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
ashmitp869
Post Partisan
Post Partisan

Year - Month nor sorting in visual

Hi All,

How can I sort the Year and Month like

Juk 2024 , Aug 2024 and Sep 2024

 

ashmitp869_0-1727674007947.png

I already tried this

ashmitp869_1-1727674073800.png

 

Thanks

2 ACCEPTED SOLUTIONS
Ritaf1983
Super User
Super User

Hi @ashmitp869 
According to the picture, you have sorted the 'Year Month Code' by itself. Instead, you need to sort the 'Month Year' column by the 'Month Year Code' column.

Ritaf1983_0-1727674613543.png

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

Kedar_Pande
Super User
Super User

@ashmitp869 

 

 

  • Select the Year-Month column.
  • Head to Sort by Column and pick Year-Month Code.
  • That's it! Your Year-Month is now perfectly sorted.

Your Kudos/Likes are much appreciated!
If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.
Regards,
Kedar Pande
www.linkedin.com/in/kedar-pande

 

View solution in original post

2 REPLIES 2
Kedar_Pande
Super User
Super User

@ashmitp869 

 

 

  • Select the Year-Month column.
  • Head to Sort by Column and pick Year-Month Code.
  • That's it! Your Year-Month is now perfectly sorted.

Your Kudos/Likes are much appreciated!
If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.
Regards,
Kedar Pande
www.linkedin.com/in/kedar-pande

 

Ritaf1983
Super User
Super User

Hi @ashmitp869 
According to the picture, you have sorted the 'Year Month Code' by itself. Instead, you need to sort the 'Month Year' column by the 'Month Year Code' column.

Ritaf1983_0-1727674613543.png

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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
Top Kudoed Authors