Problem: Matrix Table combines records with same name in one row

[OmarSaleh]

Hello, 

I'm facing a problem with Matrix table that shows values from different tables related to employees performance, where all tables are linked to Employees table by the employee unique ID (primary key). The employee ID changes when the employee gets promoted or move from one team to another in the organization. 

For Example: 

Employee Name: Joan  -  ID: 123  - Department: IT 

if the employee moves to another departement, his info will be:

Employee Name: Joan  -  ID: 333  - Department: Sales    (new ID) 

The problem I'm experiencing with Matrix table is that it combines both records of the employee (before & after team changing) into one row as the table has Employee Name in Rows field, although the Employee table is linked to all other tables by the Employee ID which is unique value. I need to separate them even if the name of the employee is the same so that Joan (in my example) should have 2 rows with the same name but different values. 

Here is a screenshot of my real project. 

Note: - Amer should have 2 rows, since he has 2 unique ID. 

          - Empolyee table is linked to Interactions table using the unique ID (as primary key) 

I would highly appreciate if anyone could help. Many thanks in advance! 

[Greg_Deckler · Accepted solution]

@OmarSaleh Add your EmployeeID to your visual. Turn off word wrap. Use the sizing handles for the column to shrink your column down to nothing, effectively hiding it.

[OmarSaleh]

Thanks @Greg_Deckler for your quick response! Actually the table should treats this employee with 2 IDs, as if there are two different employees with the same name. Further, the ID shouldn't be visiable on the table. 

So simple what I'm trying to do is to have a dedicated row for each ID, not employee. 

[Greg_Deckler · Accepted solution]

@OmarSaleh Add your EmployeeID to your visual. Turn off word wrap. Use the sizing handles for the column to shrink your column down to nothing, effectively hiding it.

[Icey · Accepted solution]

Hi @OmarSaleh ,

Power BI won't show the same record into two rows. Therefore, please try the method @Greg_Deckler mentioned and here is an example:

Best Regards,

Icey

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

[Greg_Deckler]

@OmarSaleh Add Employee ID below your Employee Name in your Rows field well for the matrix.

[OmarSaleh]

Hi @Greg_Deckler , it didn't work unfortunatelly. 

It still shows one expandable name. 

when expanding, it shows the ID.

[Greg_Deckler]

@OmarSaleh That's what I was going for actually. Well, if that's not acceptable, create a calculated column the concatenates Employee Name and Employee ID and use that instead?

Column = [EmployeeName] & " - " & [EmployeeID]