Forum Discussion
OmarSaleh
5 years agoHelper I
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 (...
- 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.
- 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
5 years agoCommunity Champion
OmarSaleh Add Employee ID below your Employee Name in your Rows field well for the matrix.
OmarSaleh
5 years agoHelper I
Hi Greg_Deckler , it didn't work unfortunatelly.
It still shows one expandable name.
when expanding, it shows the ID.