Order column chart by month over multiple years

[wenners68]

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? 

[v-piga-msft · Accepted solution]

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]

Hi, yes and I have marked it as accepted.

[bizbi]

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