Forum Discussion

Raja10ram's avatar
Raja10ram
Icon for Helper I rankHelper I
8 months ago

Power 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...
Need Help
Show and Tell
Tips and Tricks
cengizhanarslan's avatar
cengizhanarslan
Icon for Super User rankSuper User
8 months ago

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.

  • cengizhanarslan's avatar
    cengizhanarslan
    Icon for Super User rankSuper User
    8 months ago

    if you share .pbix I could try helping you on this.