Filtering a table on one page based on what you selected in a table on the first page

[Sheltomt]

So, I have Table A that has a list of broad categories.  Table B has subsets of that data, one to many relationship. 

I want to be able to click on "Category 1" in Table A, and then get all the "SubCategory" entries in Table B that match what I selected in Table A. 

And to make it a little more difficult, I want to be able to reverse filter as well, as in clicking on Table B takes you backwards in Table A to the matching broad categories.

I've looked at drill-throughs, but I'm really unsure if that is the appropriate way to go with my criteria.

Any suggestions/help is appreciated!

[Anonymous]

Hi @Sheltomt ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu

[Leasie_7]

Select one of the visuals then on the ribbon choose Format > Edit Interactions, icons will appear on all your visuals in the page choose the "graph" icon and not the crossed out circle. Select the other visual and do the same. 

[Sheltomt]

When I select Table A, and click on Edit Interactions, on Table A all I get is "Filters on Visual" and "Focus Mode".

I know what you're talking about, on the Slicers it has that icon.