Interaction between matrix tables

[Anonymous]

I have two matrix visuals that have a relationship using a bridge table on one common field. When I select one of the records on Matrix A, it does not filter/highlight the record on Matrix B. I've checked the interactions under formatting and it shows both tables are filtering. 

I have another Power BI report that is very similar with two matrix tables, but the relationship is set up differently. The matrix tables interact as expected.

The only thing I can see that's different between the two reports is how the relationship is set up.

Would the relationship cause the matrix interaction not to work on the report with the bridge table?

[mwimberger · Accepted solution]

Hi @Anonymous 

From what I can gather from your description there are two reasons it might not filter as you expect

1) Filter directions on the bridge table 

2) making sure you have the row / column lookup values in the matrix set to the bridge (dim)  table and not the other fact tables

Here is a link with a very simple example of a bridge using filter directions and using the Bridge (Dim) table as the filterable rows:

Hope this helps and Happy New Year!

Manfred

[v-lid-msft]

Hi @Anonymous ,

Sorry for that, We cannot understand your data model clearly, Could you please  describle the fields of each tables and the relations between tables simply ? What is the kind of connective mode you are using in this report? Please don't have any Confidential Information or Real data in your reply.

Best regards,

[amitchandak]

To help you further I need pbix file. If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[mwimberger · Accepted solution]

Hi @Anonymous 

From what I can gather from your description there are two reasons it might not filter as you expect

1) Filter directions on the bridge table 

2) making sure you have the row / column lookup values in the matrix set to the bridge (dim)  table and not the other fact tables

Here is a link with a very simple example of a bridge using filter directions and using the Bridge (Dim) table as the filterable rows:

Hope this helps and Happy New Year!

Manfred

[Anonymous · Accepted solution]

Thanks everyone for the suggestions. Unfortunately there's no way I can remove the sensitive data and still share it. I missed adding the processors names in values along with the NetworkID to rows. It's working fine.

A happy new year to all..!