Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Resolver I
Resolver I

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

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  


Found a cool solution for this with video below


And this one using calculation groups 

View solution in original post

Super User
Super User

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

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

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

Found a cool solution for this with video below


And this one using calculation groups 

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors