Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    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.

2 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

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

      Fanis