Forum Discussion
Problem: Matrix Table combines records with same name in one row
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.
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.
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.
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.
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.