Relationship between two dimension

[Anonymous]

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 Customer name, the next table only shows me the related project name, and related Employee names. 
How can I do that?

[v-eachen-msft]

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]

@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. 

[v-eachen-msft]

Hi @Anonymous ,

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

[Anonymous]

@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. 

[Anonymous]

@Greg_Deckler  maybe you can help?