Forum Discussion

o59393's avatar
o59393
Post Prodigy
6 years ago
Solved

Text filter that does not filter the table

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 w...
Need Help
Show and Tell
  • HotChilli's avatar
    HotChilli
    6 years ago

    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)

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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