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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.