Duplicate records are populating in the slicer dropdown even there are no duplicate records.

[smilika]

Duplicate records are pupulating in the slicer dropdown when taking a Text column from the existing table. When I duplicate the table and pulled same column in the slicer it doesn't show any duplicates. here the Column name is " Major Category". I have checked backend there are no duplicate records. Something is so weird. Could anyone help me to fix this. Please find the snippet for more understanding.

[smilika]

[Tahreem24]

@smilika In order to figure it out why it is showing duplicate records in slicer let's create a calculated column for length and check if there is any spaces available which make it a new entry.

Calculated Column = LEN(Table[Major Category]
Then use the table visual and put the Major category and this length column and check the result.

[Tahreem24]

@smilika From your screen shots it seems a table visual not slicer. Can you put your column in slicer and share the screenshot?