Forum Discussion
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
- AnonymousNot 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.