How to change slicer dependencies to each other?

[Anonymous]

Hi All,

I am seeing a slicer to slicer reaction I want to change.

Simply for example we have two slicers A & B. If I change slicer A value slicer B changes which is ok. But if I change Slicer B it changes slicer A.

So if slicer A is a list of companies I select a company Slicer B shows a list of employees for that company. But if I first change  slicer B first it may show a few companies the employee works for in Slicer A instead of the full list. Is there a way to stop that so the full list of companies in Slicer A stays visible?

Thanks,

-Tony

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

I'd like to suggest you use 'Edit Interaction' in 'Format' ribbon. If you have edit permissions for a report, you can use Visual interactions to change how visualizations on a report page impact each other.

For further information, please refer to the following official document. Hope it helps.

Change how visuals interact in a Power BI report 

Best Regards

Allan

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

[Anonymous]

Thanks but is did not work. I changed a screw looking indicator from white to black for the visualization/slicer to the left of the slicer that I did not want to be affected. I am wondering how Power BI Desktop determine the dependencies? Doe it use a tab order? Does it look at coordinates of slicer to the left, right top and bottom?

Thanks!

[FrankAT]

Hi Tony,

1. Select slicer A > tab Format > Edit interaction.
2. Select at slicer B crossfiltering to None.

Same procedere with slicer B.

 Regards FrankAT

[Anonymous]

Hi,

Select the slicer B (right side slicer in below image) and go to the Format tab click on Edit Interactions and remove interaction on slicer one(left slicer highlighted red)

Did I answer your question? If Yes, Give me a Kudo

[edhans]

1. Click the slicer for employees
2. Click the Format ribbon
3. Click the "Edit Interactions" button
4. Click the circle with a line through it on the company slicer. Now the employee slicer will not impact the company slicer.