Register
Log In
Unanswered
Home
Dashboards
Power Query
Power Pivot
February 12, 2016
Offline
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
Dashboards
June 25, 2016
Offline
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
Most Users Ever Online: 57
Currently Online: Meyanui
17 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Akshatraj Adig
Liesie Marais
Moet Lewis
Michelle Anderson
Veronica Gallego
krishnaraj r
Dharan Prakash Mishra
Md. Rahman
Lilian Vo
Jane Kumwenda
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
