Problem with sorting X-Axis on simple Line chart

[EricMamet]

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?

[EricMamet]

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

[themistoklis]

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]

Hi @themistoklis ,

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

[mwegener · Accepted solution]

Hi @EricMamet ,

please check you "Sort by"