Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Slicer to filter on different tables for same value

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

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

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 

Ritaf1983_0-1682909801852.png

2. Append tjis new table to the second 

Ritaf1983_1-1682909935066.png

3. Remove all columns except "site"

Ritaf1983_2-1682910051808.png

4. Remove duplicates

Ritaf1983_3-1682910165153.png

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

Ritaf1983_4-1682910431938.png

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

Ritaf1983_5-1682910516454.png

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.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

2 REPLIES 2
Ritaf1983
Super User
Super User

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 

Ritaf1983_0-1682909801852.png

2. Append tjis new table to the second 

Ritaf1983_1-1682909935066.png

3. Remove all columns except "site"

Ritaf1983_2-1682910051808.png

4. Remove duplicates

Ritaf1983_3-1682910165153.png

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

Ritaf1983_4-1682910431938.png

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

Ritaf1983_5-1682910516454.png

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.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Anonymous
Not applicable

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

Fanis

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.