Forum Discussion
Linked Slicers/Parameters for Filtering
Good morning, I'm currently working on a sales report that requires date filtering to be able to view historic sales data. Each entry in my table for sales has a sales credit date which is what t...
Anonymous , do you want two slicers?
How to use two Date/Period slicers
amitchandak Yes, but not quite how you have in the video. Using examples from the first paragraph of my post, slicer 1 would contain quarter numbers. Slicer 2 would contain a date range of sales dates from my data set controlled using a slider. The dates available in slicer 2 would be driven off of whichever quarter is selected in slicer 1. So if I had Q1 selected in slicer 1, the date range in slicer 2 would be 1/1/2022-3/31/2022. If I selected Q2 in slicer 1, the date range in slicer 2 would then be 4/1/2022-5/19/2022 since 5/19/2022 is the latest date in my data.