Fiscal year slicer

[Neha12]

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 chart shows the correct values staring from April to March, but problem is when I select all the years in a slicer, the bar chart shows the value from April to March in a series of April-14, April-15, April-16, April-17, May -14, May-15, May-16, May-17, June-14, June-15 and so on 

Instead of April 14, May 14, June 14, April 15, May 15 and so on 

Please help @AdamBoltryk , @dm-p  

Thank you

[AdamBoltryk · Accepted solution]

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,

[Neha12]

Thanks @AdamBoltryk 

That really worked