Table problem

[Anonymous]

Well I can't answer the previous topic so I'm reposting...

So, I have a small 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 makes no sense for my search. Let me explain: I have a 'UsersInformations' table with in it a list of names associated with an ID, and in the 'Prep_budget' table (the one I use to filter my tables) I only have the IDs of These persons. I can't get it to be the names that I see when scrolling my filter and not the IDs... do I have to create a new column?

So basically, to summarize, I have two tables: one with user information (so it is in this table that the two columns Name and ID are found) and a second with only IDs

For example: I have a 'food safety' 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 = Mr. What, ID 216 = Mr. Bidule and ID 328 = Mr. Truc (you should know that a buyer can also be a customer, a customer also a project manager... In short, we can find names in multiple columns). So to come back to my problem, when I apply my filters, I only have numbers (so 216, 212, 328...) and what I want are the list of names. How can I do that?

Thanks!

Emilie

@Anonymous Sorry for not answering you but I don't understand, it's a bug I don't post a message in the previous discussion anymore

[Anonymous]

@Anonymous nevermind at all, We are here to help each other and learn.

I guess you can solve this problem by applying the filter on the names, not the IDs, just get sure that your relation was built correctly between two tables, and then use the slicer or the filter function for the names!

let me know if it works!