Forum Discussion

wenners68's avatar
wenners68
Icon for Helper II rankHelper 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 sort the data if I do it for a 12 month period, but nothing longer.

 

Is there an easy way to do this? 

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

3 Replies

  • bizbi's avatar
    bizbi
    Icon for Advocate I rankAdvocate 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).

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    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

    • wenners68's avatar
      wenners68
      Icon for Helper II rankHelper II
      8 years ago

      Hi, yes and I have marked it as accepted.