Forum Discussion
Helper IPower BI – How to Reset Slicer to Default Value Based on Another Slicer Selection?
Hi Community,
I have a Currency slicer (INR / USD) and a Display Amount slicer with values:
- ONES
- THOUSANDS
- LAKHS
- CRORES
- MILLIONS
- BILLIONS
Requirement
- When INR is selected → Display Amount slicer should show
ONES, THOUSANDS, LAKHS, CRORES - When USD is selected → Display Amount slicer should show
ONES, THOUSANDS, MILLIONS, BILLIONS - THOUSANDS should be the default selection for both INR and USD
- When switching from USD → INR (or vice versa), the Display Amount slicer should reset back to THOUSANDS automatically, instead of keeping the previously selected value (like MILLIONS).
What I’ve Tried
- Created a DAX measure returning 1 / 0 to filter Display Amount values
- Applied the measure as a visual-level filter
- The visibility works correctly, but Power BI does not reset the slicer selection to THOUSANDS when the Currency slicer changes
Any best practices or workarounds (bookmarks, disconnected tables, etc.) would be greatly appreciated.
Thanks in advance! 🙏
Fig 1:
Fig 2:
3 Replies
- cengizhanarslan
Super User
1) Create TWO bookmarks
Bookmark: INR
Before creating/updating the bookmark:
-
Currency visuals show INR selected
-
“Values in” slicer → THOUSANDS
-
Show INR-only Values slicer, hide USD one
Bookmark options:
-
✅ Data
-
✅ Display
Bookmark: USD
-
Currency visuals show USD selected
-
“Values in” slicer → THOUSANDS
-
Show USD-only Values slicer, hide INR one
Again:
-
✅ Data
-
✅ Display
Theb group these bookmarks.
2) Insert a Bookmark Navigator
-
Insert → Buttons → Bookmark Navigator
-
Set:
-
Orientation: Horizontal
-
Style it to look like as possible as same as a filter slicer
-
-
Link navigator to the group
Now the navigator is your Currency filter.
Raja10ramHai cengizhanarslan
Thank You for Reply
Already we had tried the above solution.
But it was not working cengizhanarslan .- cengizhanarslan
if you share .pbix I could try helping you on this.
-
