show only 1 value in slicer based on another slicer

[eliasayyy]

hello community , 

ive been stuck on this task for a while , 

 have a paramter from 1 to 4 

i have 4 tables to show the rows and i put them each in a slicer 

dashboard 1 doesnt have the value "None" as its a default and the rest have the value "None"

my goal is when i press on 1 from parameter, all the values of the slicers dashboads 2 , 3 and 4 will only show the value "None" ,if i press 2 on paramter ,the dashboard 1 and 2 will show the values and not show the value "None" while for dashboard 3 and 4 only show "None"

here is more in depth 

this is the default one dashboard table

and this is the 2

this is 3

and this is 4

here is my visuals setup

and here is an example of what happens when i press on slicer

as you see , in paramter , i selected 1 , so in dashboard 2 all values must disapear except for "None" and if i press 2 all values must re appear except for "None" it should dissapear

[v-yueyunzh-msft · Accepted solution]

HI , @eliasayyy 

According to your description, you want to filter the other slicers based on the 1-4 slicer.

First of all, our role for slicers in Power BI is to modify the current filtering context. Currently, there is no way to affect the selection results of other slicers through the selection of one slicer.

We can only filter other slicers through the selection of one slicer, but we cannot cancel the previous selection.

So for your need , here are the steps you can refer to :
(1)This is my test data:

(2)We can create three measures:

d2 filter = SWITCH(TRUE() , 
MAX('Slicer'[Column1]) =1 , IF( MAX('Dashboard2'[Rows])="None" ,1,0),
MAX('Slicer'[Column1])>=2 , IF(MAX('Dashboard2'[Rows])="None" , 0, 1))

d3 filter = SWITCH(TRUE() , 
MAX('Slicer'[Column1])<3, IF( MAX('Dashboard3'[Rows])="None" ,1,0),
MAX('Slicer'[Column1])>=3 , IF(MAX('Dashboard3'[Rows])="None" , 0, 1))

d4 filter = SWITCH(TRUE() , 
MAX('Slicer'[Column1]) <4 , IF( MAX('Dashboard4'[Rows])="None" ,1,0),
MAX('Slicer'[Column1])>=4 , IF(MAX('Dashboard4'[Rows])="None" , 0, 1))

Then we can put this measure on the "Filter on this visual" :

And then we can just realize when we select the 1-4 and we can see the slicer data you want per slicer.

But for this , we can not realize the default selection for each slicer and we can not cancel the selcetion when we modify the 1-4 slicers (This is not support now in Power BI ).

So i think you need to create a "Clear all slicer" button when you need to modify the 1-4 slicer or cancel the selection in the other slicers.

For this , you can refer to :
Create Apply all and Clear all slicers buttons in reports - Power BI | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly