Cannot find string with slicer

[Applicable88]

Hello,

I have a table visual and and a slicer where I filter a stocknumber. The stocknumber is alpha numeric, and Im not sure if the problem lies within that it has spaces in it. These stocknumbers look like this:

Stocknumber

rtf 54 hgd 665

hs74g dge   hhh d

55 66 gdgdfg gg

Now I don't really know how the slicer search engine actually works, but even if I sometimes copy that number from that very table visual as a countercheck and put it into the slicer "search" field,  it cannot find these rows in that tablevisual with that stocknumber. 

Its also doesn't work from time to time when I put it in by hand. 

How can I solve this?

Thank you very much in advance. 

Best. 

[v-yanjiang-msft · Accepted solution]

Hi @Applicable88,

I create a sample according to the data you provide.

When put the column in a table visual, it renders the middle space as a single space.

In a slicer, it also renders a single space, but if you manually enter a single space, it will not be filtered out.

If you copy the data source and paste in the search bar, it appears.

So, not the data changed in the search bar, but the data render differently in visual.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Applicable88 , Can you check if text filter can help in this case

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381309?src=office&tab=Overview

[Applicable88]

Thank you @amitchandak, that tool is working pretty well. Unfortunately it has no preview of similar results. 

I also tried to find the underlying issue why the original search slicer doesn't work and run some test.

For example the stockmaterial is like "R35GG LL" . I copy that text string from that table visual to the input of the slicer and then it becomes: "R35GG                     LL" . Where do the spaces suddenly come from?  

And even when I delete all the spaces it or just put in "R35" it won't find that stocknumber. Everything is formatted as string datatype. 

I hope that can be fixed. 

[Applicable88]

I found the pattern why it happens, but not how to solve it:

I have two tables. The first one is the facttable, where stocknumber is not distinct:

Stocknumber

11 ff gg

12 ffzz

1234          ll

TTZZ55556

and table 2, a dimension table which has a 1: N - relation ship to table 1:

Stocknumber2	Category
1234          ll		16

Apparently I can only find Stocknumbers which are also in table 2. But the slicer is definetely filtering for column "Stocknumber" and not "Stochnumber2" from the second table.  It still doesn't explain why copy a text string from the table value like "R35GG LL" becomes like "R35GG                     LL" in the input field of the slicer.