Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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")
I've tested by adding another clerk in the emp table
Proud to be a PBI Community Champion
@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.
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")
I've tested by adding another clerk in the emp table
Proud to be a PBI Community Champion
Thanks @PattemManohar
your solution is working and found another solution using search and selectedvalue function in a meassure.
thanks all for the support.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |