Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Visual B
Thanks, Mark
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?
@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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!