Visual Filter through bridging table

[Anonymous]

Hi all,

Need a help here.

Following is my table connections

What I want to achieve is that, I want to create a visual slicer with "Region" from the "Site Names" table and it will filter "Forecast Database" for all the countries which is within the "Region Hierarchy" in the "Site Names" table.

Currently it does filter but also adds the rows of data that is not supposed to be shown for that region.

[Anonymous · Accepted solution]

Hi @Anonymous ,

I'd like to suggest you add a concatenated column to merge these fields and extract all concatenated values to create a bridge table link other tables. (Notice, single fields can't mapping different table records correctly, hierarchy fields not able use as relationship key)

Relationship in Power BI with Multiple Columns 
Regards,

Xiaoxin Sheng