Forum Discussion

DaleC's avatar
DaleC
Regular Visitor
8 years ago
Solved

Sort by Month

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

 

 

Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Have the X axis column in MMMM YYYY format.

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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