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...
Need Help
  • Icey's avatar
    Icey
    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.

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you SO much! I used the measure option because I had to provide the options instead of hoping the user would know with the text box. Your post was extremely helpful and worked perfectly- the gifs really helped!