Forum Discussion

Matt_Nold's avatar
Matt_Nold
Regular Visitor
9 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
    9 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.

Matt_Nold's avatar
Matt_Nold
Regular Visitor
9 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
9 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