No search option with filters

[jwi1]

Good day,

I have a question about this filter in the FILTERS PANE.

Why is the seach box not visible?

I have other filters which shows a seach box in the filter.

Thanks for your help in this,

John

No search option:

with search option:

[Gordonlilj · Accepted solution]

Hi,

I believe you can only use the search option if the filter is a text data type

[v-chuncz-msft · Accepted solution]

@jwi1 

Here is a similar idea, you may leave a comment and vote it up.

[victorviro · Accepted solution]

As the search option of filter is only available for text data type columns, I think you can convert the integer column to a new column of string type with the DAX's function CONVERT and then apply the filter in that column.

[jwi1]

Thanks for your reply.

John

[v-chuncz-msft · Accepted solution]

@jwi1 

Here is a similar idea, you may leave a comment and vote it up.

[Gordonlilj · Accepted solution]

Hi,

I believe you can only use the search option if the filter is a text data type