How do I take the data given to me from a filtered table and put it in a new visual?

[Jverburg]

Is there anyway to take the results of a filtered visual and put them in a new visual? Specifically can I take one column from a filtered visual and display a different visual based on that data? For example, if I had a table with campaign name, contact, and account name, and I filtered it by campaign name. Could I take the resulting Account names and put them in a new visual that displays all opportunities attached to those accounts? The first table would show only opportunities attached to the contact because that is where the connection is between campaign, contact, and account. But I want a second visual that shows all opportunities related to account regardless of contact. Please Help.

[Ritaf1983]

Hi @Jverburg 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Jverburg]

Opportunity Table

Opportunity Name	Account ID	Contact ID	Opportunity ID	Opp Created Date
Nova Nexus - Product 1	123	AMELI	233	1/1/2023
Nova Nexus - Product 2	123	ETHAN	234	12/1/2023
Crestwood - Product 1	321	LEOHA	235	6/19/2023
Apex Synergy - Product 2	456	NOAHC	236	8/10/2023
Zenith - Product 1	654	ADRIA	237	5/11/2023
Zenith - Product 2	654	ADRIA	238	1/16/2023
Zenith - Product 3	654	HARPE	239	10/10/2023

Account Table

Account Name	ID
Nova Nexus Enterprises	123
Crestwood Innovations	321
Apex Synergy Solutions	456
Zenith Dynamics Group	654

Campaign Table

Campaign Name	Campaign ID	Campaign End Date
Operation Celestial Harmony	1	1/2/2023
Project Quantum Nexus	2	6/3/2023
Crimson Horizon Initiative	3	7/4/2023
Stellar Unity Campaign	4	11/5/2023
Shadow Serenity Crusade	5	12/20/2023

Campaign Influence Table

Campaign ID	Opportunity ID
1	233
1	234
1	239
1	235
2	236
3	236
4	235
4	233
4	237
4	238
5	236
5	239

This is the result im hoping for

Basically, if I change the campaign name in the slicer, It will update the first table visual, then the second table visual will be filtered by those resulting account names in the first visual and showing all opportunities related to those account names. (this is sample data not real data)