Edit Interactions options grayed out for one slicer

[lauriemclolo]

Hopefully the picture will help explain what I am trying to do.   I am pretty new to power bi and took over a dashboard from a prior employee.  There is a 1st  slicer on the page that is supposed to only affect the visual on the bottom half of the page.  I added 2nd slicer that I want for the top half of the page, and I do not want it affected by the 1st slicer.  However, when I go to the 1st slicer and choose "format", "edit interactions", the option to remove the interaction with the 2nd slicer is grayed out. 

For example, you can see that the 1st slicer in the pic is filtered on "Quarterly", so the 2nd slicer is only showing "Quarterly" in the filter options, when it show show the whole list ("quarterly", "yearly", "monthly",e tc.)   Am I misunderstanding how these work?

[v-pnaroju-msft · Accepted solution]

Thankyou, @Ritaf1983, for your response.

Hi @lauriemclolo,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

Based on my understanding, the issue you are experiencing arises because slicers in Power BI automatically filter each other if they are based on the same table or connected tables through model relationships. In your case, Slicer 1 (Quarterly) is filtering Slicer 2, which is the expected behaviour in this setup.

Furthermore, the "Edit Interactions" option does not apply between slicers; it only controls how slicers affect other visuals such as charts or tables. This is why the interaction option appears greyed out when you select a slicer.

Kindly follow the steps given below to ensure that both slicers work independently:

1. Create a separate (disconnected) table for the values of the second slicer.
2. Use this new table in the second slicer instead of the original one.
3. Update your visuals or calculations to refer to the selection from this disconnected slicer wherever necessary.

This configuration will allow the two slicers to function independently: Slicer 1 can filter visuals in the lower section, and Slicer 2 will remain unaffected, controlling only the top visuals.

If you find our response helpful, please mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.

Should you have any further questions, please feel free to contact the Microsoft Fabric community.

Thank you.

[lauriemclolo]

Thank you.  I will have to find some tutorials on slicers to in order to understand the affect of slicers on separate pages vs the same page and across visualizations.

[Ritaf1983]

Hi @lauriemclolo 

It's difficult to understand what exactly you're trying to do or what the issue is just from the screenshot.
In general, interactions can be set from any visual that has interactive filtering behavior.
If the "Edit interactions" option is grayed out, it's likely that you've selected a non-interactive visual like a text box, or possibly a group of visuals (after using Group), which does not support interaction configuration.

To provide a more targeted solution, I recommend you share the PBIX file along with a clear explanation of the desired behavior — using any public cloud sharing service.

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