Forum Discussion

tanehome1's avatar
tanehome1
Helper I
1 year ago

filtering data with multiple keywords parameters

I need a DAX to search multiple keywords to filter data. In my case, I would need to filter with OR operation, meaning that all rows that include any of the keywords are shown. user can write one, t...
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for the reply from mark_endicott  and rohit1991  please allow me to provide another insight:

Hi, mark_endicott 
Thanks for reaching out to the Microsoft fabric community forum.

You may try the following visual objects:

For details, please refer to:

Import Power BI visuals from AppSource or from a file - Power BI | Microsoft Learn


Here are my results:

1.Before search:

2.After search: 

Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
 

Best Regards,

Leroy Lu

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

tanehome1's avatar
tanehome1
Helper I
1 year ago

thanks a lot for your support 

i've tried it but actualy it shows no data when filter with error "too many values filter the data or choose another field" noting that i've near 100k rows.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, tanehome1 
    Could you please let us know if his response resolved your issue? If it did, kindly accept it as the solution.

    Of course, if you have your own solution, feel free to share it. This will help other community members with similar issues find a resolution more quickly.

     

    Thank you in advance

     

    Best Regards,

    Leroy Lu