Forum Discussion
Include duplicates in slicer
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 ...
You could create a calculated column to combine the two columns into a unique identifier with the following:
UniqueID =
COMBINEVALUES("-",Table[StudentName],Table[StudentId])This will create a column with "Ann-1", "Bob-2", "Mila-3", "Mila-4", etc. You can then use this column in your slicer.
Hope this helps,
Parker
Hi Anonymous . Thanks for replying! I don't want to display the ids in slicer. Is there any other way to do?
Hmm I don't think I know a way to do that with a slicer. An alternative approach would be to simply use a table as a slicer. You could then show all names with respect to their ID's but a table obviously comes with some limitations. Hopefully someone else knows how to accomplish this!
-Parker
