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...
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
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.
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
Anonymous Attached !!