Forum Discussion
Filter a visual table using selected row in another visual table
Hi All,
Need a help on achieving the following scenario. I need this to find sutable replacement for the employee who has applied leaves. I want to show two tables in power bi and want to filter the table 2 using table 1. both table are visual tables.
if i click row of Jack in the table 1, table 2 should be omit the record of Jack as he cannot replace himself and it should show only Managers based on Jack's Job (to find similar available job role). both tables are join using emp id.
table 1 - leave table
table 2 - employee table
Anonymous Please try the below steps, might be helpful.
Create a new calculated column in Emp Table as below
LeaveFlag = IF(ISBLANK(LOOKUPVALUE(Test302EmpLeave[EmpID],Test302EmpLeave[EmpID],Test302Emp[EmpID])),"N","Y")
Emp Table EmpLeave TableRelationship
Emp Table visual
I've tested by adding another clerk in the emp table
7 Replies
Anonymous ,
You may refer to the post below.
https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Options/m-p/573381#M270846
Thanks for the reply v-chuncz-msft ,
in my case what i am expecting is, when select a row in table 1, the table 2 should filter based on the values in selected row.
for example i am looking for something like below.
Table = SUMMARIZE('Table2,FILTER('Table2','Table2'[Emp Name]=X))
i need to pass the selected row's Emp Name value to X, so that based on my selection the new table should be change.
