Duplicate Text in Multiple Text Filters

Hi andrewa521 ,

If you can accept the existence of only one slicer, and then filter one slicer to filter the two results, you can refer to the following method:

Sample data

Table 1:

Table 2:

Following your explanation, you want text filter 1 to put the ID column of Table 1 and text filter 2 to put the ID column of Table 2. Then Text Filter 1 can sync the entered text to Text Filter 2 after entering the text.

You can create a third table with distinct IDs to solve it.

Third table created using DAX:

Table =
DISTINCT ( UNION ( DISTINCT ( 'Table 1'[ID] ), DISTINCT ( 'Table 2'[ID] ) ) )

Create the relationships.

Now you can see the result. The field in the text filter visual is from the third table.

Best Regards,

Stephen Tao

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