Filter slicer visual to only show certain data

[Neqom]

I have 2 tables. Table 1 with the following structure:

Buyer ID - Name
1 - John
2 - Maria
3 - Ted
4 - Jack
5 - Sofia

Then I have another table (Table 2) with multiple columns and one of them is the Buyer ID.
Not all BuyerID exist in Table 2

I need to add an slicer visualization where the dropdown shows the buyer names but only the ones that exist in Table 2.

When adding the "Name" field of the Table 1 it populates the dropdown with all Buyer (Including the ones that doesn't exist in Table 2)
If I add the Buyer ID from Table 2 it only shows the one that exist but is showing the ID instead of the name.

Appreciate any help on this.

[Anonymous]

Hi @Neqom ,

Below is my table1:

Below is my table2:

You can try to create a slicer with table2 name:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.