topic Fiscal year slicer in Developer

Fiscal year slicer

Neha12 — Mon, 24 Apr 2023 14:10:08 GMT

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

Re: Fiscal year slicer

AdamBoltryk — Tue, 25 Apr 2023 08:51:58 GMT

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,

Re: Fiscal year slicer

Neha12 — Fri, 28 Apr 2023 07:46:10 GMT

Thanks @AdamBoltryk

That really worked