Forum Discussion
Search for multiple text values (with OR condition)
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
6 Replies
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
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
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=Overview
Unfortunately, I don't know anything else...
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!
Thankshi, 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 contexthi Alpesh
if the comments column has exact this value then only Man will search the following data
ManUtdManchester 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.
