Show slicers dynamically

[Nikhil_AZ]

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 selects Top Parent AZID, name and level from filter by slicer, only search slicer should be visible.

And if someone selects % child change or sales change then at the same place where search slicer resides, it should hide and change range slicer should become visible.

Please suggest how to achieve this.

[v-kpoloju-msft · Accepted solution]

Hi @Nikhil_AZ,

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]

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.

[Nikhil_AZ]

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]

hello @Nikhil_AZ 

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.

[Nikhil_AZ]

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

[MasonMA]

Hi, 

There's a tutorial video from Bas. I hope this helps. 

Dynamically Enable and Disable Slicers in Power BI 

[Nikhil_AZ]

Thanks @MasonMA 
It's still visible as grayed out, and my requirement to hide it completely.

[MasonMA]

There are more tutorials, including conditionally formatting the Header font color, but the caveat is they all require to set up your slicer as Vertical list, otherwise the selection box with 'All' wouldn't disappear. I'm not sure if this would be the default design you were looking.  

https://www.youtube.com/watch?v=LdoHLWiMlhA 

https://www.youtube.com/watch?v=g-4w8Wp0bqg&t=94s