Text filter that does not filter the table

[o59393]

Hello everyone

I added a text filter in order to easily recreate a table.

The problem is that when you enter a value, the table will not be updated. But when you use a drop-down cutter, you will.

For example, I use: 1868815 in my slicer and will correctly display the values:

And the text filter will show all values in the table:

How do I get the text filter frequently?

pbix.

Thank you!

[NeelAb]

Hi @o59393 ,

Not that it makes any difference now to your question.

I have a observation here about "Text filter" - if  table name changes, text filter doesn't work and I had to remove existing "Text filter" visual and replace with new visual.

Let me kow if this observation is true at your end.

>>> Rename the table - use the "Text filter" - if it doesn't work - remove the existing visual - replace with the new one.

Solution provided by @HotChilli works perfectly fine for numbers.

Best!

[Felix_Calderon]

I've changed in PowerQuery and Data View, too, and now it's working.

[HotChilli]

Relationships and directions.

The text filter on Material2 can't filter anything because of the relationship direction.

[o59393]

Hi @HotChilli 

I changed the text filter to use rp (2) and same result.

Should I set up the relationship in both ways from rp(2) to material1 and material2?

Thanks!

[HotChilli · Accepted solution]

There's more than one issue here.  Text filter filters text not numbers (it will filter them if both fields are set as text).

The tables material1 and material2 have duplicate entries (filtering from many-to-one might work but does it make sense) -> I edited that and went off and tested many to one filtering , it can work but it doesn't really make sense)

[o59393]

Hi @HotChilli 

Changed it to text and it worked.

Thanks!