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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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