Forum Discussion

nmck86's avatar
nmck86
Post Patron
7 years ago

Text Search for Multiple Words

 

Hello, 

 

As many of you know when using your email through outlook you can search for things like SMITH and PRINTING and you will see either or and all combinations of those 2 words. I would love to be able to allow my end users to do that inside Power BI utilizing the word clouds and text filters available. You can add filters but that limits the options available to the end user. I want them to have flexibility in their search. In the image below it would be great if you can search for "BINDER" and "XEROX" and see the details for the combination but then if another user wants to look at "ACCESSORIES" and "EASEL" they can. Any thoughts on how I could accomplish this? Below is a link to the sample file in quesiton. 

 

 

https://drive.google.com/file/d/16SG45YE384Fwghew_o630p3TMXFJBBuz/view?usp=sharing

 

4 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi nmck86,

     

    Though it isn't as smart as outlook, you can try it like below. Please also consider the order of the words. 

    bush * collection

    Text_Search_for_Multiple_Words

    Best Regards,
    Dale

    • nmck86's avatar
      nmck86
      Post Patron
      One more question, is the only way to get the words individually and collectively is to search separately? Below is only if both words are used.
      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee

        Hi nmck86,

         

        I'm afraid so. I didn't see anything "Below'. What is it?

         

         

        Best Regards,
        Dale