Get only matching rows in different tables when filtering on date

[Anonymous]

Hello,

As mentioned in the subject, I have 3 tables in one report. they have matching and mismatching columns, is it possible to return only matching rows from these 3 tables when filtering? For example, for a certain day i have:
table 1                 table 2               table 3
A                          A                       A
C                          B                        B
E                          C                        C
                            D                        D
                            E                         E
how to only return A, C and E in all three tables when filtering?
thank you very much 🙂

[v-lili6-msft]

HI, @Anonymous 

You could use this way as below:

Create the relationship for these three tables, 

Note: all the cross filter direction are "Both", and Cardinality are many to many(*:*)

Then drag this column field from three tables into visual level filter/ page level filter/ report level filter

and all of them set is not blank.

Now they will only show A,C,E value.

here is a simple sample pbix file, please try it.

Best Regards,

Lin