How to hide slicers based on another slicer selection when it is dropdown

[hidden_124a]

I have Discipline slicer and element slicer when user selects Building Performance, Landscape and Project Management from Discipline slicer then element slicer should be hidden not visible how to achieve this below i used table for discipline slicer.

can anyone help me on this in powerbi desktop. this is for dropdown slicer

Table =

DATATABLE(

"Discipline", STRING,

{

{"Architecture"},

{"Building Performance"},

{"Electrical"},

{"Facades"},

{"Landscape"},

{"Mechanical"},

{"Project Management"},

{"Structures"}

}

)

[V-yubandi-msft]

Hi @hidden_124a ,
Could you let us know if your issue has been resolved or if you need any further assistance?

Thank you.

[V-yubandi-msft]

Hi @hidden_124a ,

Has your issue been resolved, or do you still need assistance. If you need anything else or more information, please let us know. We're here to help.

Thank you.

[V-yubandi-msft]

Hi @hidden_124a ,
Could you update me on the status of your issue? Has it been resolved, or are you still experiencing any problems. If you need more information, feel free to let us know.

[V-yubandi-msft]

Hi @hidden_124a ,

Thank you for engaging with the Microsoft Fabric Community. Power BI Desktop doesn’t currently offer a built in feature to automatically hide one slicer based on the selection of another. In this scenario, the Element slicer won’t disappear automatically when certain Discipline values are chosen. However, as @rohit1991 mentioned earlier, using Bookmarks together with the Selection Pane is a workaround that can achieve a similar show/hide effect.
Thank you for sharing your thoughts and participating in the community, @rohit1991 .

Regards,
Yugandhar.

[rohit1991 · Accepted solution]

Hi @hidden_124a 

Solution 1: Bookmarks + Selection Pane

1. Create two report states:
   • State 1: Discipline slicer visible, Element slicer hidden.
   • State 2: Both slicers visible.
2. Use Bookmarks to capture each state.
3. Add a button (or use the Discipline slicer itself as trigger with Sync Slicers) >> switch between states.
   • Example: When user selects Building Performance, navigate to Bookmark where Element slicer is hidden.
   • For other disciplines, show the bookmark with both slicers.

This works well if you want a clean “show/hide” experience.

Solution 2: Disable Element Slicer with DAX

If you don’t want to use bookmarks, you can blank out the element slicer when unwanted disciplines are chosen:

1. Create a disconnected discipline table.
2. Create a measure like:

ShowElement =
IF (
  SELECTEDVALUE('Discipline'[Discipline]) IN 
      {"Building Performance","Landscape","Project Management"},
   BLANK(),
   1
)

3. Place this measure in the Element slicer visual using Visual-level filters:
   • Add ShowElement >> filter to “is 1”.
   • When a restricted discipline is selected, the slicer will become empty (not hidden, but unusable).

[Parveen_bs_0818]

Hi @rohit1991 

Thank you for your time and assistance.

I’ve been working on hiding a slicer in Power BI based on your steps in point 3. However, I’m currently stuck at that stage. Could you kindly share either the PBIX file or provide some snapshots of your setup? It would be really helpful for me to better understand and apply the solution.

Thank you in advance for your help

[alish_b]

Hey @hidden_124a ,

Since I have been there and done that and then found a bug that cannot be resolved and reverted it, I will not advocate this approach. Basically, you can create a measure that switches between 0 and 1 based on the selection of the required options from the Discipline slicer and use that measure as a visual filter in the elements slicer. However, Power BI slicers have an interesting property of selection retention which breaks this neat illusion. Let's say you have element 'Arch' under 'Architecture' discipline, you select Architecture discipline and then Arch element, then you select the Landscape discipline, the element slicer will still retain 'Arch' element selection even though Landscape discipline does not have that element. Unless the user promises to not touch the discipline slicer after making any selection to the element slicer, the approach will fail. 
Instead of having to explain this feature/limitation to others, let the element slicer stay in the sunlight so that the cross-filtering naturally happens and the user is not left confused.

Hope it helps!