Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

 

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

 

 

 

Any idea?

 

Thank you.

 

Hasvine

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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