Forum Discussion
Solved
Slicer Search Not Working When Enabled
I have a slicer in more report as a dropdown and when search is enabled, no results are returned. I checked that the column in a text format and tried creating a new slicer but the issues remains. Th...
Hi negbc ,
Can you orovide more information on this in terms of input/output?based on infomration provided, it looks like search issue.
in DirectQuery, the slicer search feature sends the term directly to the data source, making it behave according to that source's collation rules . If your database has a case-sensitive (CS) collation, searching "product" will return zero results if the data is stored as "PRODUCT" or "Product".Please give kudos or mark it as solution once confirmed.
Thanks and Regards,
Praful
Thanks for help, I belive the case sensitivity is the issues.