Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Relationship between two dimension

Hello all,  I have a simple data model, as zou can see in the picture:   Now, I want to have the Project name, Customer name and Employee name as a filter in my report. So when I select the ...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Do you mean to create a dynamic table based on slicer(When you select Customer , project and employee appear in the table but Customer is not displayed)?

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-eachen-msft 

No, I want both projects and customers to be slicer, and when I select one customer in the slicer, the project slicer also filters and just shows the project only for the selected customer. 

The business definitions are like below: 
Each customer can have one or several projects. 

Each employee can work on one or many projects or customers. 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Greg_Deckler  maybe you can help?

  • v-eachen-msft's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    You could set all directions to both in the relationship editor.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      v-eachen-msft 

      Thank you for your reply. 

      I am aware of this possibility. But this is not a good idea. The tables you see in this image is just part of a bigger Data Model. Setting the direction to both will mess all other tables up.