Forum Discussion

Yzmaster's avatar
Yzmaster
Regular Visitor
3 years ago

Filter data in a comma delimited string without splitting into rows

Let`s assume that i have a table:

 

NamesType of workTime HH:MM

Mark

Normal00:30
John, Mark, TimPriority01:45
John, TimNormal02:45
TimNormal00:15

 

Is it possible to create slicer to select one person in comma separated values of names?

If I use split, then I`ll create uniqe rows but that will add time to my time summary calculations (splitting time is also not permitted in that case).

Need Help

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    Hi Yzmaster 

     

    You may try a custom visual Text Filter but this visual requires that you enter a name manually to filter. It supports to filter by searching a substring in a long string. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!