This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
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!
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
Hi @Anonymous ,
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
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 29 | |
| 23 | |
| 22 | |
| 20 | |
| 20 |