cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

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, when I select Company A in the Customer table I want all Company A records filtered/highlighted in the Forms table and vice versa.  The tables are joined by Customer ID in the model (there can be multiple Form records to only 1 Customer record).

 

PBI Forum Question - Filtering btwn tables.png

 

I'm not sure what I need to configure to do that but right now selecting Company doesn't do anything.  I know recent May, June, July releases say they allow this but I still can't figure it out.  Any one have ideas on what I"m doing wrong?

 

As an alternative, I tried adding a regular slicer on customer id thinking that would at least filter both tables.  Unfortunately, it didn't.  I must add the customer id slicer from both tables for both tables to be filtered.  I viewed the interactions and all seems well too. Thoughts?

 

Will someone help me solve both questions?

 

Thank You,

 

SS

4 REPLIES 4
Highlighted
Kudo Commander
Kudo Commander

Re: Filtering a table by selecting a row in another table

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.

 

 

 

 

 

Highlighted
Frequent Visitor

Re: Filtering a table by selecting a row in another table

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 

Highlighted
Super User IV
Super User IV

Re: Filtering a table by selecting a row in another table

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

 

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






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Anonymous
Not applicable

Re: Filtering a table by selecting a row in another table

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors