Slicer to filter on different tables for same value

[Anonymous]

Hello team

I am trying to do the following. I have a PBI model with many tables. 2 of them contain the information SITE.

In the one table I have the number values and on the other table I have comments.

I would like to have a slicer that when I select a particular site, both table to display the results only for that site.

If in the slicer I bring in the SITE field from table 1 only table on is being filtered. And the same with table 2, if I bring in the slicer the SITE value fro table 2 only the comments of table 2 are being filtered.

Example

Table 1

SIte   Amount

Italy    10000

Table 2

Site   Comment

Italy  Overbudget

Thanks

Fanis

[Ritaf1983 · Accepted solution]

Hi @Anonymous 

In order to link the two tables, you need to create a "sites table" as a bridge.
You can do it by following these steps :
IN PQ
1. Create refernce table of one of yours 

2. Append tjis new table to the second 

3. Remove all columns except "site"

4. Remove duplicates

5. After Close and Apply on model view, 
Fix the type of relationships in the tables created automatically.
Both should be "one to many" with a single direction

Result:
Connected tables , which you can combine , slice and dice 

Link to Sample File 
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@Ritaf1983 Thanks a lot for your help. I didnt do it exactly the way you suggested but I worked on the connections. Thanks

Fanis