I want to be able to filter a table with a multi select control where the selected values are excluded from my table. I have created the following simplified example to demonstrate my issue.
I have a multiple string value parameter called pExclusions.
I have a multi select dropdown control with a few values specified for the list.
I have a filter on Salesperson, where I am defining that the filter does not equal the values from my parameter list.
When I don’t select an values in my control, I get all the Salesperson names as expected.
When I check Anne Smith and Gerri Hinds, they exclude from the table as expected.
However, if I want to exclude all the names in my control dropdown list, it doesn’t work. If I choose Select All to check all the names (which is what I want the default to be for this dashboard), then I get the wrong behavior and all data is returned.