Forum Discussion
Two Different Date Slicers on same page
Hi, I have a quarter slicer on my data page to allow users to quickly just show data per quarter, but I have a date slicer slider to allow them to choose any date or date range they want, as well. To avoid confusion, it would be good if the dates on the date slicer just showed the quarter range when a quarter is selected (e.g. if Q2 is selected, the date slicer would show April 1 to June 30, but it actually shows whatever dates were last entered in the slicer, usually defaults to entire year). How can I make the date slicer show dates consistent with the quarter slicer selection?
Hi HillHika,
Do your two slicers use columns from the same table? If so, select your quarter slicer, go to Format > Edit Interactions and make sure that it is filtering your date range slicer (see below). I just tested it and switching between the different Year Quarter values changes the values in the Date slicer automatically.
----------------------------------
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?)P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.
Thank you! In the end, it was probably just because I had date slicers synced across two different spreadsheet sources because I tried your solution and it didn't work, then I got rid of the sync and it did.
3 Replies
Wilson_Memorable Member
Hi HillHika,
Do your two slicers use columns from the same table? If so, select your quarter slicer, go to Format > Edit Interactions and make sure that it is filtering your date range slicer (see below). I just tested it and switching between the different Year Quarter values changes the values in the Date slicer automatically.
----------------------------------
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?)P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.
Thank you! In the end, it was probably just because I had date slicers synced across two different spreadsheet sources because I tried your solution and it didn't work, then I got rid of the sync and it did.
- Wilson_
Whatever works! Thanks for the update.