I have a pie-chart visualization, that displays the total sales for each sales rep. Below the pie chart, I have a table visualization that lists the customer names for the entire company. When I select a specific sales rep from the pie chart, the table changes and displays the customers for the chosen rep. When I click on the name of a customer, the pie chart wedge (for the chosen sales rep) and the hole chart goes grey; The table listing all of the customers also goes grey and reverts back to displaying all of the customers for the entire company. I seem to be loosing filters when I click off of visualizations. Can you explain why?
I believe when you select the sales rep from the pie chart you filter all other visuals after what you selected on the pie chart. If you then select something from the table it will change so the visuals are filtered after what you selected in the table thereby losing the selection you made on the pie chart. You could see it like the single selection option that slicers have.
Holding down ctrl while selecting should allow you to keep the previous selection you've made.
I changed the interactions between the visualizations so that when I click on the table, it should not change the pie chart; yet it still does. without holding the CTRL key, what is another way to retain that fileter?