Forum Discussion

JimJim's avatar
JimJim
Responsive Resident
3 years ago
Solved

Duplicate values in slicer

Hi Guys, 

I have manually entered data in my report like below:

When I add length_band to a slicer on my report I am getting duplicates. Is it possible to get a distinct list of values?

 

Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    I think you'd need to create a table like

    Length band for slicer = DISTINCT( 'Table'[length_band])

    Link that to your existing table and use the new table in your slicer.

2 Replies

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    I think you'd need to create a table like

    Length band for slicer = DISTINCT( 'Table'[length_band])

    Link that to your existing table and use the new table in your slicer.