Partial string search on a Power BI report

[dc7669]

Hi all,

Say I am displaying this table in Power BI.  

Name	Phone
John Doe	111-111-1111
Jane Done	222-222-2222
Smith John	333-333-3333

Is it possible to provide a search box for the name field that let users to type in string such as "John" and the table will return with the lines of "John Doe" and "Smith John"?  How can it be done? 

Thanks.

dc7669

[camargos88 · Accepted solution]

Hello @dc7669 ,

You can do this using slicer, click the 3 points, and click Search.

Did I answer your question? Mark my position as a solution!
Ricardo

[camargos88]

Hello @dc7669 ,

You can do this using slicer, click the 3 points, and click Search. After you select them, the table will be filtered.

Did I answer your question? Mark my position as a solution!
Ricardo

[Greg_Deckler]

For your selector, you would use the SEARCH or FIND functions.

[dc7669]

@Greg_Deckler I think your solution probably will work.  But, I am not too familiar with "Measure", thinking that is more related to time/geography based hierarchy.  @camargos88 solution is easier for me to understand.  Thanks for sharing! 

[Greg_Deckler]

Here is another example attached.

[Greg_Deckler]

Yes, you would want what I refer to as a complex selector. I will attach examples. Basically, it is a measure that returns 1 or 0 based upon whatever condition you specify. It is based on Inverse Selector.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Selector/m-p/648290#M325

Attached complex selector examples.