Forum Discussion
Solved
Same Values in Slicer
What is the reason I have two same values in my slicer? It happened after I appended two tables. I have checked spelling and those are exactly same (ex. Europe = Europe)
Can you share your pbix file?
Are you using a lookup table for your slicer field? You would extract the column of Region and remove duplicates, then create a relationship between the lookup and data table. If you remove dupes and still see "dupes" of region names, try using Trim and Clean before removing dupes.
There is likely a trailing whitespace or non-printable character. Use the "Trim" and "Clean" functions in the query editor to see if that does the trick.