Forum Discussion
How to Sort Months Chronogically
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.
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
5 Replies
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
Great what is the function for the column that i do? Will it be Month Number = ?
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
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.
