Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Slicer search not finding values

I am having an issue with finding items in the slicer search bar. I have a category of values which is about 20,000 long, so I provided a slicer with a search bar.  However when certain values are typed into the search they are not being found in the list.  I have verified the values do exist and have data assosicated with them.  Could this be that the list is just too long and the search function is truncating the list?  Example( Hansel Group is in the data, yet I type Han in the seach bar and I get Hanselman and Hansford, but no Hansel shows up, so I complete the full name, and get no results) 

Thanks for any help you can give. 

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous 

    I build a sample table to have a test.

    I tried Slicer search and other search like Tile search Slicer By Tme Ag, Text filter.

    You can add in this place:

    All of them can get the right result.

    You can try to use  Tile search Slicer By Tme Ag to have a test. If you still couldn't find Hansel, please show me more details about your date model or you can share your pbix file with me by your OneDrive for Business.

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous 

    I build a sample table to have a test.

    I tried Slicer search and other search like Tile search Slicer By Tme Ag, Text filter.

    You can add in this place:

    All of them can get the right result.

    You can try to use  Tile search Slicer By Tme Ag to have a test. If you still couldn't find Hansel, please show me more details about your date model or you can share your pbix file with me by your OneDrive for Business.

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous 

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem or share me with your pbix file from your Onedrive for Business.

     

    Best Regards,

    Rico Zhou

  • Were you able to find a solution that wasn't using a custom slicer?