One Filter for two columns on two tables.

[Anterrio]

I have searched for an answer multiple ways, but either my search doesn't describe it correctly, or I am the only one trying to do this.

I am trying to filter two different tables based off the same data set that shows in two different columns.

Here is the scenerio.

I work in Bay A.  I need to be able to see the defects found in my area in one table and the defects caused by my area in another table but I only want to use one slicer to control both tables.

I need to be able to just choose Bay A and table one show everything that shows Bay A in the found in column, and table two show everything that shows Bay A in the caused by column.  Every time I try to do this, it either filters both columns or neither.

This is what I am trying to do

      Original Data                                        Slicer                                 Table 1                                           Table 2

[v-yifanw-msft · Accepted solution]

Hi @Anterrio ,

Depending on the information you have provided, you can follow these steps below:

1.Create a new table as a slicer.

2.Create relationships for the three tables.

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

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