Forum Discussion

Matt_Nold's avatar
Matt_Nold
Regular Visitor
8 months ago
Solved

Multiple search options

Hi all,    I am trying to create a search tool that allows users to enter up to 4 terms, with the ability to choose and/or between search fields A&B, and C&D, and additionally and/or between the AB...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 months ago

    Matt_Nold The only default visual that allows free text entry that I know of is the Q&A visual and PowerApps visual but I don't think that the Q&A visual is really useable in the way you want. You could try third party visuals like the Text search slicer or the preview Text slicer.

Praful_Potphode's avatar
Praful_Potphode
Super User
8 months ago

Hi Matt_Nold ,

 

For this we will need to create 7 Disconnected tables.

3 tables will have AND/OR as values.

the other 4 will have words then using measure you will have to manipulate the output.

I have tried one approach in the sample pbix file.

Please check it.

 

please give kudos or mark it as solution once confirmed.

 

Thanks and Regards,

Praful

Matt_Nold's avatar
Matt_Nold
Regular Visitor
8 months ago

Thanks Praful, but I can't do tables with word to select, I am working with free text healthcare data so the possible things my users want to search is nearly limitless.

  • Praful_Potphode's avatar
    Praful_Potphode
    Super User
    8 months ago

    Hi Matt_Nold ,

    what you can try next create a duplicate copy of the search text column and then replace space with special character(for example ~).then create a measure which will give 1 or 0 depending on the word found using CONTAINSSTRING. and add measure to a table.

     

    Thanks and regards,

    Praful