Forum Discussion
Sorting graph based on fiscal month.
Hi ajdm2007 ,
You need to select your MonthName column and then sort by the desired column(Fiscal Month). Then use MonthName in your visauls. Look at my screenshot in previous reply.
In your screenshot, you have selected fiscal month column and sorted by fiscal month column, which is wrong.
Sort your month coulmn in teh date table by a month number column.
In your case, select MonthName, ColumnTools--> Sort By Column--> Month.
Then use the MonthName in your visuals and they should sort accordingly.
Hello Shravan133
In my case is FiscalMonth, so I followed your instruccions and the graph remined unchanged.
Actually, when I add the FiscalMonth field to the graph this is what happening.
For some reason, the sorting is no working.
Any idea?
Thank you in advance,