Values not coming in the filter.

[writetofaiz]

Hi,

In Power Query, I got the below result when I filtered the existing query by certain service code. 

Then I removed the service code filter from the query and I got the full dataset. Now when I tried searching for any of the values listed above, I don't see the result. What can be the reason for it and how I can fix this issue?

[bhanu_gautam · Accepted solution]

@writetofaiz , Try number filter , Then equals to and enter your value, I think it is because your data preview is set to 1000 rows

[writetofaiz]

Thanks it worked.