cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Milagros38
Regular Visitor

matrix

Hello,
I wanted to know if it is possible to relate two matrices. I have two tables, one of percentages and the other of amounts, both tables can see area 1 and area 2. I would need that if I click on table 1 to see the areas 2 that has that table, the same thing happens with the other table, that is, if I expand one, the other expands.

It's possible?
Thank you!
3 REPLIES 3
Milagros38
Regular Visitor

Milagros38_0-1660068549322.png

Quiero que si toco mas en una tabla la otra tambien se abra, existe ese tipo de relacion? 

It should automatically interact with each other. Check the 'Edit Interactions' tab to see how the visual's interactions with other visuals are set up. 

 

Read more here - Change how visuals interact in a report - Power BI | Microsoft Docs









dhruvinushah
Super User
Super User

Hi @Milagros38 , 

I am not sure if the tables you are referring to are tables on the Power BI report panel or actual 2 different data source tables. 

You can relate anything in Power BI as long as there is the right relationship maintained between the two sources on the correct fields. 

Please read more about it here: Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs









Helpful resources

Announcements
Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.