Forum Discussion

StanHost12's avatar
StanHost12
Regular Visitor
1 year ago
Solved

Sync Filtering Between Tables

Hello! I'm relatively new to Power Bi and I've been learning as I go with things, but I've hit a roadblock that I seemingly can't find any answers out on the internet. Background: I am making a re...
Need Help
  • Selva-Salimi's avatar
    Selva-Salimi
    1 year ago

    Hi StanHost12 

     

    I think an easiest way to solve your problem is to create a column, by concatenating these three columns in both tables and define your relationship based on created column! . (remmember to use some unique characters between column concatenate to avoid mismatching)

     

    If this post helps, then I would appreciate a thumbs up  and mark it as the solution to help the other members find it more quickly.

Selva-Salimi's avatar
Selva-Salimi
Solution Sage
1 year ago

Hi StanHost12 

 

I think an easiest way to solve your problem is to create a column, by concatenating these three columns in both tables and define your relationship based on created column! . (remmember to use some unique characters between column concatenate to avoid mismatching)

 

If this post helps, then I would appreciate a thumbs up  and mark it as the solution to help the other members find it more quickly.

StanHost12's avatar
StanHost12
Regular Visitor
1 year ago

Thanks for the help Selva-Salimi !

I had seen this method online but hadn't applied it correctly or known it could be used in this scenario. From what I can see this method is working (so far) for both the test data and my actual report!