title: Power BI : Split Comma Separated Values into Filter List
body: <p>I have this data that is loaded into my PowerBI</p>
  
  <pre><code>ID Color Group                       SubGroup
  1  Blue  Clothes,Furniture,Kitchen   Men,Women
  2  Red   Electronics,Clothes         All
  3  Pink  Books,Clothes,Kitchen       Women,Girls,Baby
  4  Black Electronics,Books,Furniture Men,Women,Boys,Girls
  </code></pre>
  
  <p>I want my Filter to show this list</p>
  
  <p><strong>Filter 1</strong></p>
  
  <pre><code>Groups
  -----------
  Clothes
  Furniture
  Kitchen
  Electronics
  Books
  </code></pre>
  
  <p><strong>Filter 2</strong></p>
  
  <pre><code>SubGroups
  -----------
  Men
  Women
  Girls
  Baby
  Boys
  All
  </code></pre>
  
  <p>so when user tick Clothes box in the Filter 1, all records will be filtered to the ones that has Clothes in its Group.</p>
  
  <p>when user tick Women box in the Filter 2, all records will be filtered to the ones that has Women in its Subgroup.</p>
  
  <p>How can I achieve that?</p>
  
  <p>I tried filtering by Group and Subgroup directly but I got this in the filter</p>
  
  <p><strong>Filter 1</strong></p>
  
  <pre><code>Groups
  -----------
  Clothes,Furniture,Kitchen
  Electronics,Clothes
  Books,Clothes,Kitchen
  Electronics,Books,Furniture
  </code></pre>
  
  <p><strong>Filter 2</strong></p>
  
  <pre><code>SubGroups
  -----------
  Men,Women
  All
  Women,Girls,Baby
  Men,Women,Boys,Girls
  </code></pre>
  
  <p>which is not what I want</p>