Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Slicer capabilities with multiple text items in column

Hello community,   I have a problem that I'm sure is not unique but I have not been able to find help and I've spent way too much time trying to figure this out for myself.    I have a dataset th...
  • Icey's avatar
    6 years ago

    Hi Anonymous ,

     

    Please check:

     

    1. You can use a custom visual -- "Text Filter".

     

    2. Or, you can create a measure and then use it as a filter.

    Measure = 
    VAR SelectedOption =
        SELECTEDVALUE( 'Slicer Table'[Slicer Options] )
    RETURN
        IF ( SEARCH ( SelectedOption, MAX ( 'Table'[LOB] ),, BLANK () ) <> BLANK (), 1 )
    

    BTW, .pbix file attached.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.