Forum Discussion

shera276's avatar
shera276
Kudo Kingpin
9 years ago

Filtering a table by selecting a row in another table

Hi - I'm new to PowerBI and hoping someone can point me in the right direction.  I'm trying to filter (or highlight) a table based by selecting a row from a different table.  In my example below, whe...
BraneyBI's avatar
BraneyBI
Kudo Commander
8 years ago

Important question:  Do you have a relationship between your two tables on the CustomerID field?  You can tell by selecting the 'Manage Relationship' icon on the Home ribbon.  Your customerIDs need to be unique on the customer table. 

 

With the new Table and Matrix visuals, cross highlighting is now enabled by default.

 

 

 

 

 

ziad's avatar
ziad
Frequent Visitor
8 years ago

BraneyBI, I have the same situation except that I don't need to make a relationship between the two fields as I have both fields in the same unique table. But I want to disable the cross highliting in the Matrix visual that I am using, Please do you know a way to disable that and enable "normal filtering" so that the second table could be filtered according to the row selected in the first table.

 

Thanks for your help

Ziad 

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    shera276 as BraneyBI, did you setup the relation between two tables?

     

    ziad Can you share sample what you are trying to achieve?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I am facing the similar type of the problem. Where I have two table view and after selection on one table the row the second table should get highlighted. 

       

      Thanks in advance for helpTableMapping