Dropdown not showing values and not even allowing to choose textbox

hi,

I have text column to show Alphanumeric IDs, when i use that column in filter its showing as dropdown list plus below information box and in control at top of sheet its not showing any of the values.. how should i change this to text box or show values?


Hi @suvarna0212 :slight_smile:
problem here is that you have too many distinct values, as specified, so you cannot show the values here in the dropdown.

If you want to change the filter to a Text Box, you can change Filter Type to Custom Filter.

That would mean that the final user still has to know the exact value he/she want to get.

The dropdown with the Search Box is probably the best solution, cause by starting typing, you will find suggestions and that can guide the final user.

Andrea

hi.. if i change to custom filter equals i need to give a default value, if i dont give value then it shows empty data in table visual as below:

We need to show data n then search from one

hi.. i changed the filter to custom filter list–> custom filter.. but the filter comes to include non .. earlier it was include all.. visusal data is not displayed anyone.. How should i change back to include all..?
image

i understood.. i got the text box form custom filter–> contains..

Hi @suvarna0212 ,
so have you solved the issue? :slight_smile:
Can we close the this topic?

Thank you,
have a nice one!
Andrea