Missing data in Power Query Editor

Thank you.  I've worked out the issue.  First of all, the filter search is case sensitive so I was filtering by Text>Equals using lowercase letters but what I was filtering was all uppercase.  The other issue is that the data I was joining the two queries by had a small variation in their values, one had punctuation and one didn't.  I didn't suspect this as they both should have been the same coming from the same source.  So all sorted.  Thanks for replying Anonymous and Omid_Motamedise AmiraBedh