Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 months ago
Solved

Show slicers dynamically

Please look at the attached image. I have three slicers, Filter By, Search and Change range. Currently, all three slicers are visible all the time. Now the requirement from the team is, if user sele...
Show and Tell
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    7 months ago

    Hi Anonymous,

    Thanks for sharing the clarification. Now, Power BI doesn’t support automatically showing or hiding visuals purely based on a slicer selection slicer can filter data, but they can’t control visual visibility. The approaches already shared in the thread (bookmarks, buttons, and list-style slicer formatting) are the closest supported behaviours. Another option for some customers use is a small helper table to let users switch between Search and Change Range modes, and then applying visual-level filters so only the relevant slicer is visible on the page. While it isn’t fully automatic, it does provide a clean experience without disabled or greyed-out visuals.

    If you need a truly dynamic hide/show experience without any user interaction at all, that will require a new feature from the Power BI product team. I’d recommend submitting the idea here so it can be considered for future releases:
    Fabric Ideas - Microsoft Fabric Community

    Hope that clarifies. Let us know if you have any doubts regarding this. We will be happy to help.

    Thank you for using the Microsoft Fabric Community Forum.

cengizhanarslan's avatar
cengizhanarslan
Super User
7 months ago

Power BI does not support conditional show/hide of visuals driven by slicer values. Slicer interaction can filter data, but it cannot control visual visibility.

 

Supported workaround: Bookmarks + Buttons

  1. Create two slicers:

    • Search slicer

    • Change Range slicer

  2. Place them in the same position (overlapping).

  3. Use Selection Pane:

    • Bookmark 1 → Search slicer visible, Change Range hidden

    • Bookmark 2 → Change Range visible, Search slicer hidden

  4. Create buttons (or images) the user clicks:

    • “Search attributes”

    • “Change metrics”

  5. Assign each button to the corresponding bookmark.

This gives clean UX and predictable behavior.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 months ago

    Can we do something like-

    Place two buttons which are overlapped to each other and only gets visible as per selection.

    Like if I select "Top Parent Name" from Filter By slicer, a button gets enabled and after clicking that, Search slicer gets enabled.

    And similarly, If I select "% Child Change" from Filter By slicer, the overlapped button gets enabled and other one gets hidden and after clicking that, Change Range Slicer gets enabled.

    • Irwan's avatar
      Irwan
      Super User
      7 months ago

      hello Anonymous 

       

      i dont think you can do that in slicer filter as experts mentioned here.

      But you can do what you described if you wrap your visual in bookmark button instead of slicer.

      While slicer only can filter the data in the visual, bookmark button can snapshot what you want such as hiding visuals.

      Thank you.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 months ago

        hi Irwan 
        Also I believe we can do that with "List" type slicer only, not with the "dropdown" one.