Forum Discussion
visual table to show column using inactive relationship
Hi
I'm fairly new to Power BI and I've have looked at the other posts here but not sure if I can see one exactly like this. I'm also not very good explaining in words so have included a picture to aid my description. This picture is just a simplified representation, in the real model there are other tables.
I have a Projects table and a Times table both which use different columns to link to the same column in the users table. From the times table to get the users.DisplayName of the user that logged the time entry and from the Projects table the users.DisplayName of the manager for the project.
In my visual table I have the project details but would like to pull in the users.DisplayName using the link from the Project.managerUserIdname but it keeps bringing in the users.DisplayName using the times.userid link.
I do also need the times.userid for the users.DisplayName so require both links. How do I reference in the table visual that I want the users.DisplayName using the link from the Project.managerUserIdname.
Thanks in advance.