Forum Discussion
Interaction not working with reports
Hi,
I have following reports, where is has Start date of employees and End data of Employees. Also, I have created a Calendar table with dates.
I have created a relationship of Start date to Date as Many to one. I wanted to create another realtion End date to Date, but I could not as PowerBI not allowing and getting error
This is the actual Report -
When I am clicking on positive values (Start date of employees), I am getting employee details in following report. However, when I click on negetive value (Exit data of employee) then I do Start date of employee. Basically, I am not getting correct data.
My undestanding is that, because of the realationship, I have created with Start date - its working for Start date. And, as I can not create a realtionship with End Date, its not working for End date.
Is there a way, we can resolve this and can it start working for Start date and End Date.
4 Replies
- Arul
Super User
It can be resolved by creating inactive relationship between End date of Employees Table and date in calendar table and then write a measure for that Exit date of employee.
Could you share the sample data ?Thanks,
- Chandra_maha
Helper I
Hello Arul
Thank you for response. I have inactive relationship for End Date and Date. Following is the sample dataEmployee Name Start Date End Date b 02-10-2017 c 28-03-2021 30-12-2021 d 01-03-2020 e 31-03-2014 29-11-2021 f 01-02-2021 g 17-11-2019 h 31-03-2020 25-04-2022 i 04-05-2021 j 09-02-2014 28-03-2021 k 17-01-2021 30-08-2021 l 29-09-2018 m 02-01-2017 n 30-04-2021 08-08-2021 o 04-07-2022 p 01-07-2014 q 22-03-2020 r 21-10-2018 s 18-04-2021 30-04-2021 t 15-03-2020 u 10-03-2019 29-06-2021 v 03-11-2020 04-05-2021 w 02-03-2020 07-02-2022 x 02-06-2019 16-12-2020 y 15-03-2020 z 25-02-2014 17-06-2021 qw 05-04-2020 01-05-2022 dsd 10-06-2018 13-05-2021 fg 07-03-2021 ert 30-06-2014 25-02-2021 bgf 30-06-2019 17-10-2021 hg 28-03-2021 25-04-2022 ert 11-04-2021 07-08-2022 df 16-03-2021 xc 21-03-2021 14-11-2022 sd 16-02-2021 24-11-2021 sd 31-01-2020 14-06-2022 ew 17-03-2021 29-11-2021 bf 28-07-2019 11-09-2022 sd 01-01-2018 27-07-2021 yt 15-03-2020 07-10-2021 uj 18-04-2017 30-05-2021 iki 31-10-2019 we 02-06-2019 08-03-2021 ht 16-02-2020 30-03-2021 qw 19-01-2021 24-10-2021 vb 09-06-2019 29-08-2021 tg 03-12-2017 fg 20-01-2019 17-02-2022 sd 31-08-2019 27-02-2021
Thank you in advance.- amitchandak
Super User
Chandra_maha , Check if this can help, same as what suggested by Arul
You can refer to my blog https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970