Forum Discussion
Exact text search box
- I have a search box as below. It is set on a text column. When i entered some text in it, it returns all the results where values contain that text. For example if type in '1' , i get '1', '11', '651' etc.
- If required I could convert that text column into a numeric one. But i need to have exact text/number search capabiliy
- Is there a way to get the exact text match? is there any custom visuzlation that I could use?
- I have created that search box using the custom visualization that microsoft has provided. I have provided its details below
Anonymous
How about using a slicer? Click ... to open the Search box, enter key word to get the list of all values containing it and select the exact one you need from the list. Search box only appears in a slicer when the column is in text data type.
Or you can use Smart Filter or Smart Filter Pro which have a similar experience. Both of the custom visuals work on text-type and number-type columns.
Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
2 Replies
- amitchandak
Super User
Anonymous , I doubt seeing a option like that
v-jingzhangCommunity Support
Anonymous
How about using a slicer? Click ... to open the Search box, enter key word to get the list of all values containing it and select the exact one you need from the list. Search box only appears in a slicer when the column is in text data type.
Or you can use Smart Filter or Smart Filter Pro which have a similar experience. Both of the custom visuals work on text-type and number-type columns.
Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
