Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create Multiple Cards from a Primary Key between two tables

New to Power BI, any help much appreciated!! We have two tables with "Group Name" as the primary key.   Group Name Roles IT Developer IT DBA IT Admin IT Analyst Marketing D...
Need Help
  • v-joesh-msft's avatar
    v-joesh-msft
    6 years ago

    Hi  Anonymous ,

    I think there may not be a good way to solve your problem directly, I will provide an indirect method, but I am not sure if it can meet your needs:

    1. You can  create a many-to-many relationship between the two tables, Roles and Employee:

     

    2. Use the Group Name field as a slicer ，then create the Multi-row card (next to the Card) of the Employee field and the Roles field. After aligning the border, select Group. The results are as follows:

     

    Best Regards,

    Community Support Team _ Joey
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-joesh-msft's avatar
v-joesh-msft
Solution Sage
6 years ago

Hi  Anonymous ,

I think there may not be a good way to solve your problem directly, I will provide an indirect method, but I am not sure if it can meet your needs:

1. You can  create a many-to-many relationship between the two tables, Roles and Employee:

 

2. Use the Group Name field as a slicer ，then create the Multi-row card (next to the Card) of the Employee field and the Roles field. After aligning the border, select Group. The results are as follows:

 

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you so much!! You are a genius, this helps us get near to what we need!