Forum Discussion

jiinson's avatar
jiinson
Helper I
9 years ago
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)
General Comment
Need Help
Show and Tell
Tips and Tricks
  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    9 years ago

    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.

Sean's avatar
Sean
Community Champion
9 years ago

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?

  • jiinson's avatar
    jiinson
    Helper I
    9 years ago

    Sean Yes, I am getting the same result.

    • Sean's avatar
      Sean
      Community Champion
      9 years ago

      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?

      • jiinson's avatar
        jiinson
        Helper I
        9 years ago

        Sean

         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.