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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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