Skip to main content
cancel
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.

Reply
yakovlol
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  

1 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 

View solution in original post

4 REPLIES 4
Ritaf1983
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 

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

 

And this one using calculation groups

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

Helpful resources

Announcements
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

PBI_APRIL_CAROUSEL1

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