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

Need Help

5 Replies

  • v-eachen-msft's avatar
    v-eachen-msft
    Community 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.