How to get rid of in a List Filter?

Question

I creates a parameter "Role Name" and then I put the Role name field in the filter and made a bind to the parameter, When I add the value in the parameter, it works. When I delete it from the parameter it give me How do I get rid of the

Clare Murtagh · Accepted Answer

Hi @User_SYYDG appears because a single-value parameter that's been cleared still passes an empty string, so the filter treats blank as a value to match. A fix i have used Is to edit the role name parameter and tick “Allow Multiple Values”. A multi-value parameter with nothing selected clears the bound filter, so you get all roles back rather than . While you're in there, it's also worth setting Available Values to the Role Name column, so users pick from a list instead of free typing…hope this helps.