Forum Discussion
Filtering by dates in two columns
Thanks Sergio, I synched the sliders and they do interact with eachother. The issue is that when both slicers are have the same week range selected, it looks for rows that have both a settlement and maturity within that week, but there are none.
I would like to have the slicer operate more as an AND type operator: "show maturities within 5/15/22 to 5/21/22 AND settlements between 5/15/22 to 5/21/22"
Does any of that make sense?
The AND type operator is what both slicers are doing, maybe you want OR...
The example that you gave you're selecting the same date range, so it must be true for both dates, it's maturities date AND settlements date.
If you want OR you have to show both slicers and deactivate the sync between them.
Or did i understand incorrectly?