I am encountering an issue while working in Power Pivot, specifically with slicer interaction. In my setup, I have multiple tables linked to each other, and I am utilizing measures in a pivot table for calculations. To enhance user interactivity, I have implemented slicers based on the main data table.

The problem arises when I use these slicers to filter the data. While the slicers successfully filter the pivot table based on the selected criteria (e.g., product type like "vegetables"), they do not seem to communicate with each other. Consequently, when I click on a specific product type in one slicer, such as "vegetables," the pivot table is appropriately filtered (and measures work correctly). However, the second slicer, which should display products related to the chosen product type (e.g., "carrot," "Potato"), remains unaffected.

Desired Outcome:

I would like the slicers to work in tandem, ensuring that when I select a product type in one slicer, both the pivot table and the other slicers update accordingly. This synchronized behavior would enhance the overall functionality and usability of the Power Pivot setup.

Steps Taken:

Ensured proper table relationships.
Verified the correctness of the measures used in the pivot table.
Confirmed that slicers are sourced from the main data table.

Any insights or guidance on resolving this issue would be greatly appreciated.

Thank you!