How do I filter a table with respect to values in a second table.

[AbhinavSatija12]

I have five tables each containing data on the basis of Building ID and date. However one of the table(Let's call it 'Base Data') has Client ID as well and each client ID can correspond to multiple Building ID's. Now we want to select a client ID as a parameter when the file is opened and we want the tables to be filtered in accordance ie all building ID's corresponding to that client id in 'Base Data' table to be taken from other tables as well. eg:

if data is like: Base Data:

                      ClientID | Building ID |. . . . . .

                      ABC1     | 211kjkl

                      ABC1     | 212kasl

                      ABC2     | 221kjfd

                      ABC3     | 211kjaas

                      ABC1     | 211kjssa

 So if the client ID selected in Parameters is ABC1 then from all tables data is fetched/shown only where BuildingID is: 211kjkl,  212kasl,  211kjssa.                   

[v-huizhn-msft]

Hi @AbhinavSatija12,

If there is relationship between the five tables? If it is, please create a slicer including ClientID, which is related to five tables. When you select a value in slicer, it will return all corresponding values.

Best Regards,
Angelia