Forum Discussion
Anonymous
6 years agoNot applicable
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...
- 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.