Forum Discussion
How to Sort Months Chronogically
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
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
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,
