Toggle a between date slicer on and off

[austinb12]

I have a simple report created with one table that has a few different slicers applied to it. One slicer is setup on a date column so users can filter for values between a date range. The issue is, there are blanks in that column so those are completely removed as soon as we add the between date slicer. I am hoping there is a way with bookmarks or something else to turn that slicer on and off so that when it's on, it looks at values between the defined date range and when it is off, it either doesn't apply or looks at any values with blanks in that column. Any ideas on how I could accomplish this?

[adudani · Accepted solution]

hi @austinb12 ,

this is feasible using bookmarks.

you would need :

2 bookmarks:

One with the default slicer view.

One with the modified slicer view. ( using the "fitlers on this visual" pane, modify the slicer as per requirement)

1 button ( to toggle between bookmarka: Assign the action to this button -> select bookmark/view)

However, managing this in case of date range changes is pretty manual.

Some bookmark references: 

Make navigation easier with Power BI buttons (youtube.com) ( similar concept to this imo)

Mastering Power BI Bookmarks (youtube.com)