Power BI Dictionary

Thanks for the reply from Tahreem24 , please allow me to provide another insight:

Hi  Julia2023 ,

I created some data:

Table1：

Table2：

Here are the steps you can follow：

1. Create calculated column.

Create a calculated column for each table to represent the name of the current table.

NAME = "Table1"

2. Click Q&A visual.

3. When you enter a Value, it will automatically display which table it is in, and when you click on a table, it will display the information of that row only.

4. If you want to display the searched values in more than one table, you can create a search summary table containing all the searched information.

Create calculated table

search_table =
UNION(
    'Table1','Table2')

5. Result:

Best Regards,

Liu Yang

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