topic Re: Lock/Unlock start date on Date Slicer based on Region Selection in DAX Commands and Tips

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

AlwaysAGooner — Fri, 17 Jan 2025 09:53:20 GMT

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.

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

AnkitKukreja — Fri, 17 Jan 2025 17:47:17 GMT

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).

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

rohit1991 — Sun, 19 Jan 2025 12:28:39 GMT

Power BI:

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

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

AlwaysAGooner — Mon, 20 Jan 2025 06:42:53 GMT

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