Get value from other table by id

[Anonymous]

Hi,

I'm a newbie in Power BI. So I cannot design my Report as I want. I have this type of relationship

I want to create matrix with Employee fullname in rows, in front of him the employee status with name, emp_class with name, then Trainings and with his training_date and validity_date. All work but employee status is repeating near categories I will add my matrix values.

[amitchandak · Accepted solution]

@Anonymous, You have used it as value. Move it to row. Refer this link for better display

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

I am hosting a webinar on 25th April on Power BI, Check Details - https://www.linkedin.com/posts/amitchandak78_webinar-tech-techforgood-activity-6658266754378231808-ye5L

[Anonymous]

Since rows are a columns rows, think I must separate status from rows, but I didn't know, how?