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.
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.
Okay next thing we need to check...
Have you Unchecked Enable Load from the 2 tables you said you appended?
Or all tables you have appended for that matter?
Don't worry they'll will be updated when you Refresh and the Appended table will get the new data too
but only the Appended table will load into the Data Model