title: Filtering by keyword (string) in PowerBI
body: <p>I have a data visualization in PowerBI that is powered by SQL on the back-end. I have one particular field that I'd like to be able to filter by string-matching.  Here's what the field looks like:</p>
  
  <pre><code>me_drug_occurence
  AB
  C
  ABC
  BC
  B
  </code></pre>
  
  <p>Each letter is unique and stands for a type of drug. More letters = combinations of drugs. No letter repeats more than once for a record. I want to use the "Filters on the page" option and have the user be able to filter by drug A, B, and C. By selecting A, for example, that would show any record that contains A (records <code>AB, ABC,)</code>.  Selecting A and B would show any record which contains A OR B (records <code>AB, ABC, BC, B</code>).  And so on and so forth.</p>
  
  <p>My issue is that there doesn't seem to be an out-of-the-box way to do this in Power BI?  If I simply drag this column to the "filters on this page" sidebar, I just get options to filter by the different drug combinations.</p>
  
  <p><a href="https://i.stack.imgur.com/YPKwa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YPKwa.png" alt="enter image description here"></a></p>
  
  <p>If I choose "advanced filter", I can get closer to my goal, but it forces the user to put the keywords in manually:</p>
  
  <p><a href="https://i.stack.imgur.com/44YE9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/44YE9.png" alt="enter image description here"></a></p>
  
  <p>So, my question is how can I accomplish a filter on this visualization that would look something like this:</p>
  
  <pre><code>Filter:
  A
  B
  C
  </code></pre>
  
  <p>Where you could filter by any record that contained A, B, or C, or some combination thereof.  Do I need to create a custom measure?</p>