Forum Discussion

EricMamet's avatar
EricMamet
Helper I
5 years ago
Solved

Problem with sorting X-Axis on simple Line chart

I try to display measures with an axis made of Months in the format YY-MM

 

If I sort in Ascending order, May 2021 ends up after Dec 2021...

 

If I sort descending, it's still wrong!

  Any idea why is the X axis not sorted properly?

 

 

Need Help

4 Replies

  • themistoklis's avatar
    themistoklis
    Community Champion
    5 years ago

    X axis is text and not a number that's why during sort it is messing up the order.

    Try to create a new column where YearMonth will be in the following formay YYYYMM.

     

     

    YearMonth= FORMAT('Calendar'[Date], "YYYYMM")

     

    Make sure it is of datatype 'wholenumber' and not text

    Now Go to model section and sort the column which is shown on X axis in the diagram based on the newly created column. See image below

     

    • mwegener's avatar
      mwegener
      Most Valuable Professional
      5 years ago

      Hi themistoklis ,

       

      this should not be the problem, because even in alphanumeric sorting the dates have the correct order.

       

  • EricMamet's avatar
    EricMamet
    Helper I
    5 years ago

    Indeed, it was solved by using the sort... option.

     

    I would have thought logical to order by default by my X Axis values but it was not the case.

     

    Thanks