Forum Discussion
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.
10 Replies
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.
Do you get the same result when pressing the top Europe only as when you press the bottom Europe only?
Meaning do you get results only from the corresponding table only?
Okay sorry so just to be clear
When you press the top Europe you get a total from both tables
when you press bottom Europe you get the same total again from both tables
and when you select BOTH Europes in the slicer you also get the same total from both tables
so in all 3 of those cases you get the same info?
