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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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