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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Sorting graphs

Hello Team,

 

I am trying to sort a chart by using my calendar below:

 

Calendar = ADDCOLUMNS ( CALENDAR ( Date ( 2022 , 09 , 01 ),  date ( 2023 , 12 , 31 ))
, "Month Year" ,  Format ( [Date] ,  "MMM-YYYY" )
, "Month Year sort" ,  Format ( [Date] ,  "YYYYMM" )
, "Year" ,  Year ( [Date] )
, "YYYY-WK" , CONCATENATE( FORMAT ( [Date] , "YYYY" ),Format(WEEKNUM([Date],2)-1,"00"))
, "Qtr Year" ,  Format ( [Date] , "YYYY\QQ" ))
 
Hasvine2022_0-1673330872925.png

 

I sorted my table using the month year sort but it is not working in my chart. 

 

Hasvine2022_1-1673331150992.png

 

 

Any idea?

 

Thank you.

 

Hasvine

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hello Team,

 

Kindly ignore. I managed to fix it by removing the x-axis "Month Year" and put it again.

 

Thank you.

 

Kind Regards,

 

Hasvine

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hello Team,

 

Kindly ignore. I managed to fix it by removing the x-axis "Month Year" and put it again.

 

Thank you.

 

Kind Regards,

 

Hasvine

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors