aquigley247
New Member
- Joined
- Apr 11, 2019
- Messages
- 1
Hi there,
I have a spreadsheet that connects several slicers to pivot tables and their associated charts. Along with the data slicers I have a timeline connected to all of them as well. When a slicer selects one or more field options, other surrounding slicers will visually indicate which options still have relevant data, as shown in the example below (hopefully):
However, what doesn't happen is the same affect if i were to select a specific month in a timeline. Not all options have data in the slicers that i have for the dates selected in the timeline.
Is there a way to connect the timeline to visually indicating slicer options that have data for the timeline filter selection?
Thanks,
Alex
I have a spreadsheet that connects several slicers to pivot tables and their associated charts. Along with the data slicers I have a timeline connected to all of them as well. When a slicer selects one or more field options, other surrounding slicers will visually indicate which options still have relevant data, as shown in the example below (hopefully):
However, what doesn't happen is the same affect if i were to select a specific month in a timeline. Not all options have data in the slicers that i have for the dates selected in the timeline.
Is there a way to connect the timeline to visually indicating slicer options that have data for the timeline filter selection?
Thanks,
Alex