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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
dgkallan
Helper II
Helper II

Months in chart showing descending from year end

I have a date table with Year, Month, Year Month

 

When I put Year Month into my chart it appears to sort the data based on the highest values from the data and not in chronological order.  

dgkallan_0-1698784709870.png

Year Month has a data type of text (which I assume is part of the problem) 

 

dgkallan_1-1698784784971.png

 

 

1 ACCEPTED SOLUTION
rsbin
Super User
Super User

@dgkallan ,

If you hover over your Visual, you should see an ellipsis (3 dots ....) in the top right corner.

Click on this elipsis and select sort axis.  Then sort by Year-Month in Ascending Order.

This should solve your issue.

Regards,

View solution in original post

1 REPLY 1
rsbin
Super User
Super User

@dgkallan ,

If you hover over your Visual, you should see an ellipsis (3 dots ....) in the top right corner.

Click on this elipsis and select sort axis.  Then sort by Year-Month in Ascending Order.

This should solve your issue.

Regards,

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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