Edit Interactions options grayed out for one slicer

Thankyou, Ritaf1983, for your response.

Hi Anonymous,

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.