Search code examples
powerbipowerbi-custom-visuals

How to create a slicer that filters information if field contains specific values?

I have a column that contains text like the following:

Name    Type 
Mark    FT
Jess    FT; #PT
Hallon  PT
Len     FT; #PT; #HT
Tessa   PT; #HT

What I'm trying to do is create a slicer that has ONLY three options: FT, PT, HT So if I choose FT, the following result would show:

Name    Type 
Mark    FT
Jess    FT; #PT
Len     FT; #PT; #HT
Solution

  • enter image description here

    enter image description here

    How to achieve this? Go to your Table, Then go to Edit queries enter image description here

    Then right click on Colum and duplicate it

    enter image description here

    Now right click on duplicate colum and click on split column by delimiter enter image description here

    Then below changes

    enter image description here

    You get something like below

    enter image description here

    Then Trim the same column enter image description here

    Then Replace Value enter image description here

    You get final Table

    enter image description here

    Go to Visualtization screen and add your column and new column and slicer you will get desired result