Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Lock/Unlock start date on Date Slicer based on Region Selection
01-17-2025
01:53 AM
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.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-19-2025
04:28 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-19-2025
10:42 PM
Thanks. How do we contorl the visibility using the measure? Is there a visual level property for this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-17-2025
09:47 AM
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).
For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.
Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
https://topmate.io/ankit_kukreja
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.
Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904
https://topmate.io/ankit_kukreja

Helpful resources
Announcements
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Recommendations
Subject | Author | Posted | |
---|---|---|---|
05-29-2024 02:24 PM | |||
07-26-2024 06:10 PM | |||
02-19-2024 07:13 AM | |||
05-08-2024 12:03 PM | |||
08-02-2024 10:40 AM |
Top Solution Authors (Last Month)
User | Count |
---|---|
29 | |
15 | |
11 | |
10 | |
8 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
19 | |
15 | |
15 | |
15 | |
14 |