Forum Discussion
Slicer Search Advanced Optimization
Hey, that didn't get me to the solution. But I found a custom filter called "Smart Pro Viz" which ignores the spacing between text and gives me the desired outcome.
Thanks!
I have already trimmed the column and convereted the text to upper case. The problem with creating a conditional column is that I have 500+ Companies in my list that would mean writing atleast 4 different conditions for each company. 😕
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?
Unfortunately I cannot establish control over the users input data. Cleansing is done once I get it on Power-BI.
What do you mean by creating a column by examples? Can you elaborate please?