Search for multiple text values (with OR condition)

[Alpesh]

Is there a way to search for more than two text values with an OR condition? Dataset is >10GB and we are using star schema with mutliple dim tables. The Condition needs to be applied to a comment (verbatim) field (can have unlimited characters) on the fact table. We need any user to be able to filter, so no hard-coding in transformation. Our users don;t know DAX so can't be something that requires a measure/custom column to be created

[Uzi2019]

Hi @Alpesh 
If user want to search for a keyword then you can use Text filter visual from App source.

But unfortunately It nly accepts single column. You can concatenate the 2 columns and use in search filter visual.

Or you can add search functionality in a slicer ( by clicking on 3 dots on top right corner of slicer). where you can add multiple columns as a hierarchy in single slicer. 

If my post helps then give kudos and accept it as a solution!
Thanks

[Alpesh]

hi, thanks but the search needs to be in 1 column. For example, we take all comments on social media. and if we want to get all comments on Man Utd we would need to filter for all the following words in the comment:
ManUtd OR Manchester United OR ManU OR MUFC OR Man United
That's a fake example, but hopefully you understand more the context

[Uzi2019]

hi @Alpesh 
if the comments column has exact this value then only Man will search the following data
ManUtd 

Manchester United 

ManU 

MUFC

Man United

if you search MUFA then only MUFA will apear.

 if you want result of all values by  searching only Man Utd then you have to mapped all the respected values.

[mlsx4]

Hi @Alpesh 

It's just an option but... Why don't you use a text filter to look for what a user need? https://appsource.microsoft.com/es-es/product/power-bi-visuals/wa104381309?tab=overview

[Alpesh]

Hi, from what I tried, you can only search for one value with the Text filter visual. We'd need to sometimes search for 4 or 5 values for the report

[mlsx4]

You're right...

There are another two visuals:

• This one does it, but I think you need to pay: https://okviz.com/smart-filter/
• This other: https://appsource.microsoft.com/en-us/product/power-bi-visuals/devscope-1156626.filterbylist?tab=Ove...

Unfortunately, I don't know anything else...