The point of the data source filter is to remove data before it hits the visualization. It sounds to me like you want a filter at a different level of granularity.
Hi, I have the same issue. I'd like to use a data source filter to set a default filter, that is used as long as it is not specifically overwritten.
My datasource is an SAP HANA via Live Connection, but the overall idea is the same.