Forum Discussion
Interactivity
Hello, I currently have an issue where I have 4 tables that have multiple columns. Each of these tablse are the exact same data except for different quarters of the year. For some reason though, the interactivity isn't working. When I hit the name of a person on one of the tables, the rest of the tablse just minimize themselves and show no data. I've tried editing the interactions, but nothing seems to work.
Hi ecodata512
Thank you very much DataInsights for your prompt reply.
Create a reasonable relationship for them based on the data in the table.
In my tests, I used the "ID" column to create a bidirectional filtering relationship for three tables.
After importing the data, click on the "Model view" on the left, you can drag and drop the table relationship in this interface.
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
In this way, it helps you to interact.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Are you able to combine these four tables into one table in Power Query (Append Queries)? This will enable you to filter the entire table via a slicer or filter.
Hi ecodata512
Thank you very much DataInsights for your prompt reply.
Create a reasonable relationship for them based on the data in the table.
In my tests, I used the "ID" column to create a bidirectional filtering relationship for three tables.
After importing the data, click on the "Model view" on the left, you can drag and drop the table relationship in this interface.
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
In this way, it helps you to interact.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
