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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Chanleakna123
Post Prodigy
Post Prodigy

Play Axis with Month-Year ( In ordering )

hi , 

i have a calendar have Month Year , and i have used animation bar to play with axis , i'd like to play this with Jan2011 , Feb 2011 , March 2011 and so on.... but now it displayed by Jan2011-Jan2012-Jan2013 and so on. 

do we have any way to perform this ? 

 

1.png

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

Create a sort column and attach to it and check

 

month year sort = format(date,"YYYYMM")

Sort_by_column.png

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

Create a sort column and attach to it and check

 

month year sort = format(date,"YYYYMM")

Sort_by_column.png

@amitchandak , you nailed it, thanks you 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 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.

Sept NL Carousel

Fabric Community Update - September 2024

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