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
Anonymous ,
You may refer to the post below.
https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Options/m-p/573381#M270846