Forum Discussion
Filter a visual table using selected row in another visual 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
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.
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.
Any other have face similar issue or scenario ?
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