Forum Discussion

Pal03's avatar
Pal03
Frequent Visitor
8 years ago
Solved

Duplicate values in slicer Please help

hello all , i have a table and a slicer with that table. The slicer for account doesnt show unique values and its repeating itself    I dont have any spaces and the data is clean. I have sorte...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Pal03,

     

    You can new a calculated table to list unique account values:

    account = VALUES(TestData[Account])

    Create a one to many relationship from 'account' to 'TestData' based on [Account] field. Add 'account'[Account] into slicer, to filter data table.

     

    Regards,

    Yuliana Gu

VoHoPBI's avatar
VoHoPBI
Regular Visitor
3 years ago

I had the same issue. Root cause was that I had the column "Grp" with duplicated entries sorted by a "Sortorder" Column.
Usually you cannot sort a column with duplicated entries by another column, that has distinct values for this duplicated entry.
But I changed the Values in Sortorder after "Sort By", so my table looked like this:
The distinct values in Sortorder seem to force the Slicer to show each duplicated values in Grp

Grp                Line                 Sortorder

Discounts      Rebates           1  

Discounts      Sales Disc        2