Forum Discussion
Solved
Fiscal year slicer
Hi, I have a year slicer and a fiscal year wise line chart that starts from April to March. I have sorted the line chart with fiscal year column. whenever I select any year in a slicer the line ch...
Morning Neha,
You need 'slave column' to correct sortation of your 'April-14' data. IMVHO best is numerical colum with format YYYYMM and then sort your column using this slave one. so your 'April -14' will be represent with 201404 in slave column.
Regards,
Morning Neha,
You need 'slave column' to correct sortation of your 'April-14' data. IMVHO best is numerical colum with format YYYYMM and then sort your column using this slave one. so your 'April -14' will be represent with 201404 in slave column.
Regards,
