Forum Discussion

madashelliam's avatar
madashelliam
Regular Visitor
10 years ago
Solved

Filtering data based on another table

I have 2 tables. Table A has list of employees and how much leave they have. Table B has a list of some of the names but only those that have agreed to a certien condition. They are linked via a empl...
Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    madashelliam You need to ensure there is active relationship between table A and B via power bi relationship view and filtering will work automatically for you. When you create relationship in power bi ensure cross-filter direction is set to Both and this will filter both table based on selection of another. Just like shown below,

     

v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

madashelliam If you have difined relationship between table a and table b, then you can use a slicer visual to filter the employees in table a. Add a slicer to your report, and drag employeeID into Field of the slicer, then you can filter the the employees in table a.

Regards,

Charlie Liao

  • madashelliam's avatar
    madashelliam
    Regular Visitor
    10 years ago

    thanks for some reason this worked were as just filtering didnt