Forum Discussion
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...
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
