Forum Discussion
Slicer Search Advanced Optimization
I am trying to optimize the search functionality within a slicer. I have created the slicer for the following column:
| Company Name |
| mathworks |
| math limited |
| u s corporal |
| 7 eleven corp |
- The problem is that few of my dashboard users sometimes type "math works" (a space in between math and works) and the filter doesn't show this option.
- Similar cases for "u s corporal", my users somtimes use "US corporal" and the search option in the filter fails to show the company.
Is there any way I can optimize this so that the users are shown the company despite the spacing errors between the words?
11 Replies
Anonymous, I'd recommend either creating a Conditional Column in Power Query whereby the inputs are cleansed / manipulated in back-end and then the slicer does it's job. For example, a few steps you would take to ensure inputs are cleansed and consistent could be using the following:
- Convert all inputs for [Column] to "UPPERCASE" or "Proper Text" or "lowercase"
- Using TRIM on the column to remove leading / ending " " spaces.
- And so on...
Otherwise, in Power Query you can also Create Column From Examples which uses machine learning to assign an output.
Let me know if you need further insight into this 🙂
Anonymous did you try creating a Column by Examples?
Also, an alternative is to prevent input errors by establishing controls over the users' data input. Can you create a drop down list or the like so you don't have to perform the cleansing?
Anonymous, ahhh that makes sense about the inputs. Here is a link that can provide guidance on Column by Examples. It's a very intuitive function.
Anonymous I now better understand what you're looking for. I'll get back to you soon.
