Manage multiple charts with a search bar

[doemorbe]

I have 2 separate tracking tables, in which I pay attention to the status of a given user for given tasks. I would like to visualize these two tables in 2 separate diagrams. The problem is that I want to create a search bar where if the user enters his name, the 2 charts are automatically modified with his values. (I mean, if I type in Adam's name, the 2 charts will show only his data)

I have tried several solutions, but so far I have not been successful. If anyone could suggest a solution, I would be very grateful.

Table 1

Name	Task	Status
Adam	xyz	in Progress
Adam	xyz	Done
Joe	xyz	no feedback
Peter	xyzq	Done

Table 2

Name	Task	Status
Adam	xyz	no feedback
Eve	xyz	done
Peter	xyz	done
Joe	xyz	done

[Daniel29195 · Accepted solution]

@doemorbe 

create a table containg all the names from both tables as such : 

calculated table ==>  dim_names =  distinct( union  ( distinct(tbl1[name]) , distinct(tbl2[name]) ) 

then link this table to both tables on the name column. 

now in your search bar use the name column from the newly created table .

[Anonymous · Accepted solution]

Your solutions is worked @Daniel29195 ,that is so great!

Hi, @doemorbe 

The method provided by super user does work. I created the following example data:

Table1:

Table2:

I downloaded the following text search visual object from the visual object marketplace:

The following visual objects were created in my report:

I created a calculation table using the following DAX expression:

Name Table = 
VAR _table1_name = SUMMARIZE('Table1','Table1'[Name])
VAR _table2_name = SUMMARIZE('Table2',Table2[Name])
RETURN SUMMARIZE(UNION(_table1_name,_table2_name),Table1[Name])

Use this calculated table with Table1, Table2 to create these relationships below:

Using the name column of the calculation table in the Text search slicer, the results are as follows:

If your Text Search slicer only works for one visual object, you can check the following visual object interactions to make sure that slicer has enabled filtering for your chart:

I have provided the PBIX file used in this instance below.

Best Regards

Jianpeng Li

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

[Daniel29195 · Accepted solution]

@doemorbe 

create a table containg all the names from both tables as such : 

calculated table ==>  dim_names =  distinct( union  ( distinct(tbl1[name]) , distinct(tbl2[name]) ) 

then link this table to both tables on the name column. 

now in your search bar use the name column from the newly created table .

[doemorbe]

Hi Daniel, thank you very much for your help, it works perfectly.