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.

MNedix's avatar
MNedix
Solution Sage
1 year ago

Heya,

On my opinion you should definitely get rid of the Many-to-Many and Bidirectional relationships, to me they are the Twilight Zone of PowerBI (the results vary depending on the positioning of the planets).

I would simply create two dimension tables: one with the Category and the second with Region and Sub-region and use them to create proper relationships.