Forum Discussion

dc7669's avatar
dc7669
Icon for Resolver II rankResolver II
6 years ago
Solved

Partial string search on a Power BI report

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...
Need Help
Tutorial Requests
  • camargos88's avatar
    camargos88
    6 years ago

    Hello @dc7669 ,

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

    Capture.PNG

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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

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

dc7669's avatar
dc7669
Icon for Resolver II rankResolver II
6 years ago

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!