Lock/Unlock start date on Date Slicer based on Region Selection

[AlwaysAGooner]

Hi,

I have a need to lock (disabled) the start date on a date slicer for one region while the other region wants the start date to be enabled.
For e.g., If Europe is selected on the Region Slicer, lock the start date on the date slicer, if Asia is selected then enable the start date selection on the date slicer.

I am not sure if this can be achieved but any leads/suggestions will be greatly appreciated.

Thanks.

[rohit1991]

Power BI:

1. Create a mapping table for regions to toggle (e.g., lock = "Europe").
2. Use a measure to control slicer visibility: LockStartDate = IF(SELECaEDVALUE(Region) = "Europe", 1, 0)
3. Overlay two slicers (one locked, one interactive) and use the measure to toggle visibility.

[AlwaysAGooner]

Thanks. How do we contorl the visibility using the measure? Is there a visual level property for this?

[AnkitKukreja]

Hi! @AlwaysAGooner 

You can try using the bookmarks,

• Locked Slicer: Configure this slicer to have a fixed start date or show a single date range that cannot be changed. (For example, by limiting the filter range in the slicer settings.)
• Enabled Slicer: Configure this slicer to allow full user interaction (start and end dates can be freely adjusted).