Forum Discussion
Get value from other table by id
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.
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
2 Replies
- amitchandak
Super User
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