Forum Discussion
jiinson
Helper I
Helper ISame 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.
jiinsonHelper I
Helper INo 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.
Sean
Community Champion
Community ChampionBefore we go any further in the Query Editor - right-click the Region Column in the Appended Query and both Trim and Clean