Forum Discussion
Combining multiple date fields into a single slicer
Hi,
I have a requirement where I have multiple date fields such as engagement start date, end date, opportunity start date and end date.
I would have to combine all the four date fields into a single dropdown where only the selected date slicer should be displayed.
For eg. When I select the engagement start date from the dropdown, I will have to see the date slicer only for that particualar selection and when I change the selection to another date field from the dropdown, I will have to see the date slicer for that corresponding field and so on.
Any suggestions for this?
Thanks in advance!
3 Replies
Hi Pragadeesh,
You might look into setting up bookmarks on buttons that let you swap out slicers for the four date fields (ie: hide all the slicers and show only the one slicer you want). If you think that sounds feasible and aren't sure how to do that, I'm happy to elaborate.
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)Hi Wilson_ , Unfortunately, I cannot use bookmarks in my scenario since I have to combine the date fields into a single dropdown. As and when I select a particular date field from the dropdown the corresponding date slicer must be displayed.
Any suggestion as to how we can achieve this?Pragadeesh,
You can use bookmarks to switch out the date slicer being displayed. Check this sample file I put together. Let me know if that doesn't work for your needs.
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
