Filter not affected by other filter

[Smackcat]

Hi experts,

I have the following table:

KPI	Coin	Value
Sales	Local	100
Sales	Foreign	200
Units sold	No coin	50

With two slicers (KPI, Coin) and one measure.

When I select Coin = "Local" or Coin = "Foreign", "Sales" is shown in the KPI slicer, as they belong to each other in the table. Neverthless, when I select Coin = Local or Coin = Foreign, the option in KPI slicer "Units sold" disappeared as it has a non selected value in Coin slicer. I wonder if there's a trick I can use in order to show "Units sold" in the KPI slicer eventhough the selected filter "Coin" (Local or Foreing) doesn't belong to it.

I don't want to use the Coin = "No coin" option because when I select this alternative, "Sales" disappears in the KPI slicer, and I want the two values ("Sales", "Units sold") to be visible in spite of the Coin filter

[vicky_ · Accepted solution]

You'll need to turn off visual interactions between your slicer(s). 
There's a page here on how that works: https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...

[Smackcat]

Omg I didn't know it existed. Thank you!