Power BI report where user has ability to enter values as text to search and return required records

[Anonymous]

for some of the PBI reports, user wants to filter records by entering values in text field. They want to have ability to enter one or more values by comma seperation and PBI should do the search and return records related to those values.

Example: A table that has column_1 which contains thousands of distinct values. user wants a filter where they can enter few values and PBI return matching records to those values. Given the data list is high, they are not looking to scroll through and do multiple selection.

Constraint : cant use third party tools due to security restriction.

[parry2k]

@Anonymous It is not a common ask especially when working with Power BI, it is mostly read-only. The only way you can do this is (cumbersome process), to create a Power App, embed in Power BI, and use that input to search in the Power BI semantic model. Again, it is doable but not straightforward.

The 2nd option is to have user input data in some external file and then click refresh, take that input in the external file to search the records. End of the day, nothing is out of the box but there are complex, not user friendly solutions.

[Anonymous]

It is still a read only ,user dont want to go through thousands of values from drop down and multiselect each filter value checkbox.  Looking for Options to create such text entering and applying data filter on column.

[parry2k]

@Anonymous there is no data input visual that you can use or add logic to search in the records, not sure if there will be any solution for this.

[Anonymous]

Thanks @parry2k , Its understood we dont have built in slicer/filter to meet the requirement.  I believe the ask is not unique and there should be someone out there implemented it. I have psudo logic in mind 
Logic - Have a table /parameter which accept user input. Once user enter data, perform pivot of entered data with comma seperated delimit. Then match the values with actual table column and return records matching the criteria.else return all records.