Sorting graphs

[Anonymous]

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" ))

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

Any idea?

Thank you.

Hasvine

[Anonymous · Accepted solution]

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