Dashboard filter should override slices filter on the same column

[mistercrunch]

Superset version

0.20.5

issue

When using a dashboard level filter on say region = 'north america', against a slice that would have been saved with another filter like region = 'europe', the resulting query filters on both with an AND clause, which leads to returning no data.

Instead, the filter on region at the dashboard level, when specified, should override existing slice level filter on another region(s).

workaround

remove the conflicting slice-level filter on the related slices where a dashboard-level filter is expected to be applied. This is not ideal but is a pretty easy fix.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.