I am trying to filter a pivot table field using Label Filter

%3CLINGO-SUB%20id%3D%22lingo-sub-1587887%22%20slang%3D%22en-US%22%3EI%20am%20trying%20to%20filter%20a%20pivot%20table%20field%20using%20Label%20Filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1587887%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20filter%20using%20Contains%20with%20multiple%20values%20such%20as%20red%2C%20green%20or%20blue.%20I%20have%20tired%20various%20separators%20but%20once%20i%20add%20the%20second%20word%20i%20get%20no%20values%20returned.%20I%20have%20tried%20comma%2C%20semicolon%2C%20a%20colon%20and%20a%20space.%20Each%20attempt%20returns%20no%20results%20after%20the%20second%20condition%20is%20added.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1587887%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1587958%22%20slang%3D%22en-US%22%3ERe%3A%20I%20am%20trying%20to%20filter%20a%20pivot%20table%20field%20using%20Label%20Filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1587958%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F759037%22%20target%3D%22_blank%22%3E%40Chrislbf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20doesn't%20work%20such%20way%2C%20it%20shall%20be%20only%20one%20condition.%20There%20are%20workarounds%20like%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsuperuser.com%2Fquestions%2F896831%2Fmultiple-label-filters-in-a-pivot-table%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsuperuser.com%2Fquestions%2F896831%2Fmultiple-label-filters-in-a-pivot-table%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I would like to filter using Contains with multiple values such as red, green or blue. I have tired various separators but once i add the second word i get no values returned. I have tried comma, semicolon, a colon and a space. Each attempt returns no results after the second condition is added.

1 Reply
Highlighted

@Chrislbf 

That doesn't work such way, it shall be only one condition. There are workarounds like this https://superuser.com/questions/896831/multiple-label-filters-in-a-pivot-table