Forum Discussion

wenners68's avatar
wenners68
Helper II
8 years ago
Solved

Order column chart by month over multiple years

Hi,   I want to sort my data by month over several years and end up with a chart showing "Jan 2017", , , and so on until "Jan 2020" I created a column (MonthYear) with the format above and can sor...
Need Help
Show and Tell
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi wenners68,

     

    By the solution from bizbi, have you solved the problem?

     

    If you need additional help, please share some data sample and expected output, so that we can help further investigate on it?

     

    Best Regards,

    Cherry

bizbi's avatar
bizbi
Advocate I
8 years ago

1. Format the year column as a whole number [Year].

2. Format the month column in MM format using format function in a calculated column:

Month MM=FORMAT(MONTH('Table'[Date]),"00")

3. Next, concatenate both these columns to give the Order column:

Order=[Year] & [Month MM]

4. Use this column for sorting (format as whole number if necessary).