Forum Discussion

gauravkumar16's avatar
gauravkumar16
Frequent Visitor
2 years ago

Sorting months spanning two years

Ritaf1983     I have months starting from Sep2022 to Sep2023. In line chart, they are not appearing chronologically. Can anyone pls help how to achieve this.  
Need Help
DOLEARY85's avatar
DOLEARY85
Resident Rockstar
2 years ago

Hi,

 

you'll need to sort your column by something that runs in the correct order.

 

Select your month-year column and use 'sort by column' on the 'column tools' tool bar then select the field to sort by. If you don;t have anything you could create something simple like a number that follows the month and year in your calendat table. e.g 

 

Column = value(month('Calendar'[Date])&year('Calendar'[Date]))

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

 

  • gauravkumar16's avatar
    gauravkumar16
    Frequent Visitor
    2 years ago

    Thanks Doleary58 for replying.

     

    I have a column as Month and Year in format "YYMMMM" so Sep 2022 is written as 092022.

     

    Now in line chart i have put this field in X-axis. Also, I have sorted the data by this column as you explained.

     

    But still it is not sorted chronologically whether you do ASC or DESC.

     

     

    Isn't it?

     

    • DOLEARY85's avatar
      DOLEARY85
      Resident Rockstar
      2 years ago

      Can you check that your month year serial column is numeric?

      • gauravkumar16's avatar
        gauravkumar16
        Frequent Visitor
        2 years ago

        Thanks for pointing that out.

        Now I have made it numeric but still it is not chronological.