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

mkjit256's avatar
mkjit256
Icon for Advocate II rankAdvocate II
2 years ago

I had the same problem and i was able to solve it by a simple copy of the [Account] Column to a new column and that fixed my problem.