Forum Discussion

BIfanatic's avatar
BIfanatic
Icon for Resolver I rankResolver I
8 years ago

Missing search option within slicer

Hi everyone,   In my report I experience some issues with the functionalities of the slicer.   I have two 'identical' slicers: both with a column that is formatted as text. The number of distinct...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

BIfanatic,

 

We cannot reproduce this issue. As you may see on this link which describes that the issue might be caused by the numbers of items in you slicers. However, you said that the number of distinct values for each column is equal (and so is the length of the list). 

 

So could you please provide us more information about your report, so that we can make further analysis. You can upload a pbix file to Onedrive or any web storage and share the link. Do mask sensitive data before uploading.

 

Regards,

Charlie Liao

BIfanatic's avatar
BIfanatic
Icon for Resolver I rankResolver I
8 years ago

v-caliao-msft

 

I have to change my initial post. The number of distinct values are the following:

- column A ~ 807 distinct values -> search option

- column B ~ 868 distinct values -> no search option

 

Could this relatively small difference cause the search option to disappear?

If you would still like to check the .pbix file, let me know.