Static Filtering while clicking on visual

Dear Community,

I am looking for a solution to click on a value in a visual and set this selection automatically as a filter that effects all the rest. I know about cross filtering and highlighting. But in general I am looking for a scenario like this:

• I select a product category in a table visual
• I will then jump to another sheet to do further analysis (I do not want to do a drillthrough) or even to stay on the same page with only having data based on the selection
• I will set the selection as a filter that is shown in the filter pane on the right

I know there is some kind of option to right click an then click on include/exclude, but this is only effective for the same visual.

Any ideas?

Thanks a lot and best regards,

Alex