Forum Discussion

OmarSaleh's avatar
OmarSaleh
Helper I
5 years ago
Solved

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

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 (...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    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's avatar
    Icey
    5 years ago

    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's avatar
Greg_Deckler
Community Champion
5 years ago

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

OmarSaleh's avatar
OmarSaleh
Helper I
5 years ago

Hi Greg_Deckler , it didn't work unfortunatelly. 

It still shows one expandable name. 

 

 

when expanding, it shows the ID.

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    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]