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.
Before we go any further in the Query Editor - right-click the Region Column in the Appended Query and both Trim and Clean
Sean didn't I say that already? ;)