Hello, I have created 2 Power Bi dashboard pages with 2 separate Excel files. The similar points of the file are that they both have "Emp Name", "Date" and other columns, however each Excel sheet is used for a different performance measure thus some of their columns are different.
Both dashboard pages will display the employee names and their scores based on the marks from the respective excel sheets.
After creating the 2 performance dashboard I want to create a drill through page (page 3) where when a employees name is clicked on either page 1 or page 2 the employees name will appear on page 3 with both of the performance scores in a line chart
The problem I am facing now is that when I am on pg 1 and clicks on an employees name to be drill trhough on pg 3, the value of the performance score of pg2 that is shown in pg 3 does not correspondes to that selected employee.
Is there any way to let the selected employee name from a page to be also applied to the other page in the drill t??
Appreciate all the help I can get 🙂
