Forum Discussion
Post ProdigyMultiple date slicers for one visual possible?
I am trying to see if it is possible to use multiple date slicers for one visual.
I tried with both "Relative Range" and "Slider" ones together, but it appears that "Relative Range" one overrides the "Slicer" date slicer.
So, basically, I am trying to apply two date slicers to a Matrix visual.
I see one option (from other developer) using "Bookmark" (as shown below).
Is this the only option?
Thanks.
Let's say your date column goes from 2022-06-01 to 2022-06-08
In slicer A you select 2022-06-01 to 2022-06-03
In slicer B you select 2022-06-03 to 2022-06-05
The intersect of these is ony one date - 2022-06-03.
Another example
In slicer A you select 2022-06-01 to 2022-06-03
In slicer B you select 2022-06-05 to 2022-06-08
This will result in an empty dependent visual as the intersect has no data.
3 Replies
- lbendlin
Super User
If you apply two slicers to the same date column then the result will be the intersect of the values of both slicers.
- JustinDoh1
lbendlin Sorry, I am not clearly understanding what you meant by "intersect of the values of both slicers". So, I guess, in this case, because "Relative Dates" tends to be smaller range, it would work (if the date ranges are within the Slider), but if I use Slider, and if the range is wider and covering Relative Dates range, then, visual would not change, right?
- lbendlin
Let's say your date column goes from 2022-06-01 to 2022-06-08
In slicer A you select 2022-06-01 to 2022-06-03
In slicer B you select 2022-06-03 to 2022-06-05
The intersect of these is ony one date - 2022-06-03.
Another example
In slicer A you select 2022-06-01 to 2022-06-03
In slicer B you select 2022-06-05 to 2022-06-08
This will result in an empty dependent visual as the intersect has no data.
