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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors