Forum Discussion
Same Values in Slicer
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.
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?
No problem.
So, my clicer is in single selection mode. (is not able to press multiple selection)
In some reason, when I press the top Europe both top and bottom Europe are selected. So I am getting same total.
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? ;)
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.