Add Search capability to a numeric type field with out transforming data

[SrinathLM10]

Problem: I need to add a search capability to a userID field, which is of numeric type. However, it seems that search functionality is only possible on text type fields.

Constraint: There are restrictions on making changes to the model or transform data step, and there's a live connection set to the data.

Attempts So Far:

• I can't change the data type in the model view or use advanced query because that requires a transform data step.
• I can't create a calculated column using DAX, as I couldn't find any option to create a new column in the report.
• I tried creating a measure to extract the userID from other columns, but creating a measure on a non-calculated column is not supported.

Does anyone have any suggestions on how to tackle this issue or if any of my observations above are incorrect? Any help would be greatly appreciated. Thanks!

[SrinathLM10]

Thanks for the reply @lbendlin Since the field is of numeric type the filter pane does not allow you to search

[lbendlin]

Cannot reproduce -

[SrinathLM10]

Sorry, I did not understand the comment 'Cannot reproduce.' As you can see in the snapshot, we cannot search for numeric type.

[lbendlin]

I can search for any number in that filter?

[lbendlin]

Add that userID field to the filter pane, for example as "Filters on this page"

Note: There is a 1 million row limit.