Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Merge results from two visuals

Hi, I have a PBI report that has two Table visuals that I need to merge together. They each have diferent filtering. I want to move the count1 for Bradley from visual A into visual B. I have included an example of the visuals below. 

Visual A                                         

U156531_4-1705616078978.png

   

Visual B          

U156531_3-1705615968547.png

 

Thanks, Mark

 

 

 

 

 

2 REPLIES 2
Anonymous
Not applicable

Can I union the two visuals or do I need to create a separate table in the Data Pane from the one already being used to populating the two visuals?

Second question - Is there a table created behind each visual that can be referenced and manipulated?  

Daniel29195
Super User
Super User

@Anonymous  Hello , 

from my understanding , you want to show values from table 1 and table 2 into one table visual .. 

one way i can think of to achieve what you want, it to create a new table containing all the values you need to show . 

you can use union for this. 

 

and then you can work with DAX to calculate the intended measure base on the filter context . 

you can use. 

NB :  the complexity of the work will depend on the complexity of the model . 

 

 

let me know if this helps. 

Best regards, 
Daniel 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors