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.
OmarSaleh
5 years agoHelper I
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.