I have three slicer, one for year, one for month and a third one for day. I would like each to remain static with all years, months and days in chronological order, with those not available in view but greyed out. Is this possible and if so can someone help me with this?
DH
Hi Diana
I am using Excel 2010 and this should also work in Excel 2013.
You can refer to the attachment for one way to do what you wanted.
I have created a Due Day field to get the Day portion from the Date.
I have also grouped the Date field by Days, Months and Years.
This will allow you to create the 3 slicers you wanted.
Please note that the day/month/year will only appear in the slicer if they are available in the data. i.e. if the date 31st does not exist in the data, it will not appear in the Due Day slicer etc.
Hope this helps.
Cheers
Sunny
