Forum Discussion
How to get table info
Well I can't answer the previous topic so I'm reposting... So, I have a little problem on Power BI: I want to create three new filters with buyers, project managers, and one on requesters. However,...
In situations like these you want to have a data model with dimensions (Buyer table, Project Manager table, Requestor table) and facts (the transactions). For each of the dimension tables you can do an individual lookup on the 'Usersinformation' table to match the ID to the display name.
Once the data model is in place you can link via the ID field, but feed the slicers from the name fields.