How to Sort Months Chronogically

[AndreasA]

I have viewed other solutions to another post but they are a bit confusing. So at the moment I have a chart that starts alphabetically starting with April and ending with May. Instead, I want to start with Jan and end with May on the bar charts. I have made a column with Month and another with Year. Then tried to create a custom column called concatenate but it didn't work. Any help would be apperciated. 

[a_mixed_life]

Another option is to create a DateFilter table. See screenshot. Then create a relationship. You can then sort by MonthofYear on the Month column.

You can also download the Calendar from Microsoft Azure Marketplace.

[spaxia]

Hi,

Make a column yearmonth 201601 - 201602 etc...

In modeling select the column that contains April, May etc and select Sort By column yearmonth.

Hope this helps

--silvano

[AndreasA]

Great what is the function for the column that i do? Will it be Month Number = ?

[v-sihou-msft]

@AndreasA

According to your description, you want to have you month names appeared on axis and sort by month number. Right?

In this scenario, you have to achieve it on dataset level, you just need to click on your Month Name column and select Month Number in "Sort By Column".

Regards,

[a_mixed_life · Accepted solution]

Before you created your own column, do you already have a column that shows a date? Like Posting Date? If so, go to the link below where you can get a table for Date (Requires Azure Login). Then I would create a relationship between the datekey and the Posting Date.

Then take the the MonthName and Sort By Column against the MonthofYear.

https://datamarket.azure.com/dataset/boyanpenev/datestream