Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Interaction between matrix tables

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?

Need Help
  • mwimberger's avatar
    mwimberger
    6 years ago

    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's avatar
    Anonymous
    6 years ago

    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..!

     

4 Replies

  • mwimberger's avatar
    mwimberger
    Resolver II
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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..!

       

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    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,