Forum Discussion

yaliang's avatar
yaliang
New Member
2 years ago
Solved

How to filter data in different tables

Hi   I have 5 tables and each is independent of the other. No any connection created among the tables. What I want to do is to search a specific person's different information in these 5 tables via...
Need Help
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    Hi,

    You could create a new table with all the different values of the personal ID and then link the ID column to each column of the table where you have the personal ID information.
    By doing this and using a slicer with the personal ID of the new table, you could have the information of all the tables for each ID.

_AAndrade's avatar
_AAndrade
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Hi,

You could create a new table with all the different values of the personal ID and then link the ID column to each column of the table where you have the personal ID information.
By doing this and using a slicer with the personal ID of the new table, you could have the information of all the tables for each ID.

  • yaliang's avatar
    yaliang
    New Member
    2 years ago

    _AAndrade thank you so much, but I want to let user to input the ID instead of selecting from slicer since there're many persons, it's hard to do the  filter.