I have a requirement to sort months according to calender.
For ex: I want to create a line graph with the details shown in below table.Month Name Employees Present November 50
January47 March 23 September 54
Result should beMonth Name Employees Present January 47
March23 September 54 November 50
We can use custom sort, but it will not be optimum if we have year # along with month.
I tried to create a measure variable say MonthNumber having the formula
= if([MonthName]="January") then 1
elseif([MonthName]="March") then 3
else if ....similarly for other entries.
Drop this measure into the table and sort in ascending order. In turn, the months column is sorted according to 2nd table shown. Then hide the MonthNumber column and convert the table to a line chart.
Do you know any other ways of achieving this? Pls let me know.