Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Related table and slicer

Hello,   I have in my model, 3 tables Dim project which contains projectskey, other info and ProjectManagerSkey. Dim Employee which contains, firstname, lastname, fullname, employeeskey, employee...
Need Help
  • RMB's avatar
    RMB
    7 years ago

    Have you created the table relationship from the relationship tab within Power BI Desktop?

     

     

    After you create the table relationship it should filter the matrix depending on what columns you select, if not you can always apply a visual filter to not display blank entries in ProjMgr.

RMB's avatar
RMB
Icon for Resolver II rankResolver II
7 years ago

Have you created the table relationship from the relationship tab within Power BI Desktop?

 

 

After you create the table relationship it should filter the matrix depending on what columns you select, if not you can always apply a visual filter to not display blank entries in ProjMgr.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello, I don't have any issue with the matrix or the table.  I am able to obtain the Project Manager Name using the ProjectManagerSkey.

     

    However, it is in the slicer.  Even if I use the field project Manager from the related table, it show all the name in Dim Employee.  The Slicer does not care about the link.

     

    Maybe I doing something wrong.

    Does someone could help me with that issue.

     

    • RMB's avatar
      RMB
      Icon for Resolver II rankResolver II
      7 years ago

      What direction is the relationship? The problem could be if the columns on your slicer are from the table that can't be filtered by the other. Images or a sample pbix of what you have would be helpful.