I am filtering data based on a hierarchy, such as by state then by city and therefore am using two slicers. If I select State>Illinois, then City>Chicago, I see data for Chicago. However, if I next click State>Indiana, then Chicago is still selected under city. What I want to do is run a macro every time I select a new State to automatically remove the filter on City.

I have tried assigning a macro to the "State" slicer, but it only activates upon selection of the entire slicer, and actually locks the user out of selecting any states. Is it possible to assign a macro to a change within the slicer?

Thanks