Sort by Month

[DaleC]

Hi Have a simple problem which I hope someone can assist. Y axis is $ X axis is date (excel spreadsheet date format incl year) Generally an X axis should run chronologically eg: Jan 17 Feb 17 Mar 17 ...... Jan 18 Feb 18 and so on However when I sort by Month it throws the 2018 months ahead of the 2017 eg: Jan 18 Feb 18 Aug 17 Sep 17 Oct 17 ..... and so on Is there a solution to sort the months chronologically on the X axis?

Cheers

Dale

[v-huizhn-msft · Accepted solution]

Hi @DaleC,

For X axis, MMM Year column sort by initial letters, so it shows as what you see. Please format your date format as 201701,201702 using the format.

Year-month =
IF (
    'Calendar'[Month] <= 9,
    'Calendar'[Year] & "-"
        & "0"
        & 'Calendar'[Month],
    'Calendar'[Year] & "-"
        & 'Calendar'[Month]
)

It will show desired result.



Best Regards,
Angelia

[Anonymous]

Have the X axis column in MMMM YYYY format.