Forum Discussion
Interaction not working with reports
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
Hello amitchandak
Thank you for this information.
However, when I am checking your file and trying to replicate according to my requirements, its not working or not getting the result as expected. I tried creating following table in your file as per my requirement.
When there is no relationship between Start/End date with Date Table
- Getting unrelated data.
When creating a relationship with Start Date with Date table
- Getting the correct data.
- Also, when I am clicking on bar (Start date) following table of User information is getting filter correctly.
- However, it does not happen when I click on Exit/End Date, as there is no relationship with Date table.
- This is where, I am facing the issue
- I need solution, where If I click on End/Exit then it should filter correct data in Employee information table and Vice versa of Start date.
Thank you!