Forum Discussion

Neha12's avatar
Neha12
Frequent Visitor
3 years ago
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 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

 

 

  • 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,

2 Replies

  • 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,