I have a sheet Dashboard with a variety of slicers and space is a premium. I would prefer to select a date from a drop-down box cell AK1 via DataValidation and have that date/cell control my date slicer Cal Year.
I assume I need to use the Private Sub Worksheet_Change(ByVal Target As Range) section of the sheet but do not know how to forward the data in cell AK1 into the slicer.
Is this at all possible? Various examples I found online do not work. Any ideas?
You make a copy of the PivotTable and have the relevant field in the Report Filter area, and connect both tables to the slicer. See full details here: https://www.excelcampus.com/pivot-ta...box-to-slicer/
Thanks for your help. Unfortunately, this isn't what I am looking for. Your suggestion was to add a drop-down option to an existing slicer. My aim is to reduce/remove the slicer from view to save screen space and have the slicer/pivot tables receive input from a cell that has the required dropdown list in it.
No, I don't think you got what I meant. The single drop-down goes in the dashboard ... it's connected to the slicer, and that is connected to the pivot with items you are reporting on. You change the single drop-down and it alters your filtering in your main PivotTable. At least, that's what I think is possible.
I'll try it out, but the Slicer is connected to many pivot tables already (35) as I have to separately display much data on a dashboard. Duplicating all of them will be time-consuming and potentially slow down Excel.
You don't need to duplicate all PivotTables! You need to duplicate one, one that is connected to slicer Cal Year, and connect that to the slicer also.Originally Posted by Crawfy
Hello,
It is a good solution.
But it does not work for a time slicer.
1) I have PivotTables and Slicer (linked to multiple PivotTables including the one I will duplicate)
2) I duplicated one PivotTable, converted it to a Filter and assured that it is linked to the slicer, like in a video
When I filter this filter-like PivotTable it does not affect neither my slicer nor any PivotTable linked to this slicer.
Is there any way to create a drop-down list for a time slicer? Thanks in advance!
Last edited by olegv; 11-19-2021 at 07:37 AM.
hello, did you resolve the problem? i am facing the same needs
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks