title: Have column with multiple values in powerBI, for use with a slicer
body: <p>I have a column with the following data</p>
  
  <pre><code>|  spoon
  |  fork
  |  fork &amp; spoon
  </code></pre>
  
  <p>I would like to add a slicer to my page that has two options: Spoon, fork.
  When Spoon is selected it shows the result for the rows for Spoon and fork &amp; spoon. When Fork is selected it shows the result for the rows for Fork and fork &amp; spoon
   </p>
  
  <p>Can this be achieved in powerbi?
   </p>
  
  <p>If not directly, I was thinking that formatting my data like this could help perhaps? Does powerBI have an option to see values divided by semicollons as multiple values?</p>
  
  <pre><code>|  Spoon
  |  Fork
  |  Fork ; Spoon
  </code></pre>
  
  <p>EDIT:
  Bit more info on my actual table layout:</p>
  
  <pre><code>| Service A |  revenue |  category 1    
  | Service B |  revenue |  category 2
  | Service C |  revenue |  category 1 &amp; 2
  </code></pre>
  
  <p> </p>