Bug description

Bug: I have a dashboard consisting of a table with a filter on one of the columns. The filter allows multiple values. A particular row appears in the chart when I only add one value to the filter, but if I add two values the row disappears from the chart although one of them is the right value for the row.

Expected behavior: a filter that allows multiple values would return all rows that match one or more of the values selected.

To reproduce: this may depend on your data as I haven't observed this behavior consistently and I'm not clear what types of data would trigger the issue.

1. Create a table chart.
2. Add the chart to a dashboard.
3. Add a filter on one of the rows in the table, and set it to allow multiple values.
4. Select one value in the filter and observe what data is returned.
5. Add another value to the filter. All the data previously returned should still be returned, plus any data matching the additional filter value. But in my case some of the data previously returned disappears.

I can't share a screenshot as my data is customer-sensitive. I gather from kapa.ai that this is a known issue but I wasn't able to find a specific issue on Github - apologies if I missed one.

My company is using Superset 3.1.3 but kapa.ai tells me this may occur with newer versions too. If that's wrong and this is known to be fixed in later versions, please let me know as it will help make a case for upgrading.

Screenshots/recordings

No response

Superset version

3.1.3

Python version

3.9

Node version

16

Browser

Firefox

Additional context

No response

Checklist

• I have searched Superset docs and Slack and didn't find a solution to my problem.
• I have searched the GitHub issue tracker and didn't find a similar bug report.
• I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.