Forum Discussion

Neqom's avatar
Neqom
Frequent Visitor
2 years ago

Filter slicer visual to only show certain data

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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.