I have a slicer that shows students name & the slicer removes duplicate names even if the students have different student ids. Here is my table: StudentId StudentName 1 Ann 2 Bob 3 ...
One of way is to use both column in slicer, it will create hierarchy level as below:
And also enable search in this slicer, so if user knows name, he just type few initial, and all duplicates are filtered on display for easy viewing and selection:
