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):
[IMG]C:\Users\aquigley\Pictures\Capt32432ure.PNG[/IMG]

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