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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
fanisgeorg
Helper II
Helper II

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 @fanisgeorg 

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.

View solution in original post

2 REPLIES 2
Ritaf1983
Super User
Super User

Hi @fanisgeorg 

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.

@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
PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors