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 ...
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

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft 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