How to get table info

[Anonymous]

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 my table I only have the ids of these people and it doesn't make sense for my search. Let me explain: I have a 'UsersInformations' table with in it a list of names associated with an identifier, and in the 'Prep_budget' table (the one I use to filter my tables) I only have the identifiers of These persons. I can't get it to be the names I see when scrolling through my filter and not the IDs... do I need to create a new column?

So basically, I have two tables: one with the user information 'UsersInformation' (so it is in this table that the two columns Name and ID are located) and a second with only the IDs For example: I have a “food security” project. I associate three people: a project manager whose ID is 212, a buyer whose ID is 216 and a customer whose ID is 328. Now we make the link with the second table 'user info ' which associates each ID with a name. So ID 212 = Monsieur Quoi, ID 216 = Monsieur Bidule and ID 328 = Monsieur Truc (you should know that a buyer can also be a customer, a customer can also be a project manager... In short, we can find names in several columns). So going back to my problem, when I apply my filters, I only have numbers (so 216, 212, 328...) and what I want is the list of names.

Thanks!

Emily

Sorry for not answering you but I don't understand, it bugs I can no longer post a message in the previous discussion

[lbendlin]

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.