Home

Why don't slicers update to reflect a timeline selection?

%3CLINGO-SUB%20id%3D%22lingo-sub-501888%22%20slang%3D%22en-US%22%3EWhy%20don't%20slicers%20update%20to%20reflect%20a%20timeline%20selection%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-501888%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20create%20a%20pivot%20table%20and%20add%20two%20slicers%20and%20select%20a%20value%20in%20one%20slicer%2C%20the%20other%20slicer%20updates%20to%20reflect%20the%20values%20that%20have%20been%20filtered%20in%20and%20out%20by%20the%20selection%20on%20the%20first%20slicer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20add%20a%20timeline%20slicer%20and%20select%20a%20date%20range%2C%20the%20regular%20slicers%20do%20not%20update%20to%20reflect%20the%20values%20that%20have%20been%20filtered%20in%20and%20out%20by%20the%20selection%20on%20the%20timeline.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20how%20Excel%20is%20supposed%20to%20behave%3F%20Our%20users%20are%20getting%20confused%20by%20this%2C%20as%20for%20example%20they%20select%20a%20month%20on%20the%20timeline%20and%20then%20look%20at%20the%20accounts%20slicer%20and%20see%20that%20all%20accounts%20were%20apparently%20active%20in%20that%20month%2C%20when%20they%20weren't.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20article%20seems%20to%20confirm%20the%20confusing%20behaviour%20we%20are%20getting%2C%20but%20I%20would%20really%20like%20to%20get%20an%20official%20confirmation%20that%20this%20is%20the%20intended%20behaviour%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Foffice-watch.com%2F2017%2Fusing-slicer-timeline-together%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Foffice-watch.com%2F2017%2Fusing-slicer-timeline-together%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-501888%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20pivot%20table%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
KendallLister
Occasional Visitor

When I create a pivot table and add two slicers and select a value in one slicer, the other slicer updates to reflect the values that have been filtered in and out by the selection on the first slicer.

 

When I add a timeline slicer and select a date range, the regular slicers do not update to reflect the values that have been filtered in and out by the selection on the timeline.

 

Is this how Excel is supposed to behave? Our users are getting confused by this, as for example they select a month on the timeline and then look at the accounts slicer and see that all accounts were apparently active in that month, when they weren't.

 

This article seems to confirm the confusing behaviour we are getting, but I would really like to get an official confirmation that this is the intended behaviour:

 

https://office-watch.com/2017/using-slicer-timeline-together/