Is it Possible to do Date Between slicer - but that by default will display Currrent Month

[yakovlol]

Hello, community,

Do you know if there is some workaround with Date Between slicer?

So the client wants to have a Date filter (something that we have on WEB) - so by default when the page opens the slicer show - the current month ( something like 2/01/24 - 2/27/24) BUT also this slicer should filter an earlier date range. So there is a way to filter data in December'23 and so on.

I tried t find a way how to work around in this, but cannt find any way. 

Creation of another filter that will be ON or Off the current month  - is not an option, unfortunately. such a variant was declined  

[Ritaf1983]

Hi @yakovlol 
Unfortunately, we don't have this functionality.
The closest workaround to this scenario is by using some button change slicer types.
Something like I did in the attached pbix.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[yakovlol]

Hi @Ritaf1983 Thanks for your approach. I did some workaround like this, but I have an issue when on the page there are already 2 bookmarks - and when you change a slicer and switch to another bookmark - the slicer doesn't change to the Date range that you've already picked on the first bookmark.

So when you already have bokmarks it's hard to provide nedeed logic 

Like you have picked in date range 2/01/24 - 2/10/24 ,and then switch to another bookmark and there you will again click on Date range and again pick up dates

[Ritaf1983]

Yep, it has its limitations, but this is all we have.
The user has to clear a slicer before he changes it's type...

[yakovlol · Accepted solution]

Found a cool solution for this with video below 

https://www.youtube.com/watch?v=Xi86HHEaY_M

And this one using calculation groups

https://www.youtube.com/watch?v=KBEsPGxDxHM&t=906s