Dynamic Filter

Hello, I am currently working on a Metabase project for a finance dashboard. I am encountering an issue when creating two filters, namely "Period" and "Product." If these slicers are not used, the values in the chart appear blank. However, when they are applied, the chart displays values as expected.

I am working on this in an SQL question, and I have set everything as follows.
the filter :
WHERE {{period}}
AND {{product}}

image

You seem to be adding a default value though ... Are you sure it's not the default being applied and there is no data for the past 7 days?

I'm not sure. I just want to try whether setting the default value will have an impact or not.

Actually, I want to use this query as a dynamic filter:

CASE 
   WHEN dsd.std_department = 'INPATIENT' THEN dsd2.std_department
   ELSE dsd.std_department
END AS provider

I have a case where I have both a department and a provider. Essentially, they are not on the same level. If there is a specific department, it will be directed to the provider.
For example, I have departments A, B, C, D, and E. Department E, in general, is further broken down into providers.
Would the CASE WHEN statement above be possible to use as a dynamic filter with the settings shown in the image?

I'm not sure. I just want to try whether setting the default value will have an impact or not.

Actually, I want to use this query as a dynamic filter:

CASE 
   WHEN dsd.std_department = 'INPATIENT' THEN dsd2.std_department
   ELSE dsd.std_department
END AS provider

I have a case where I have both a department and a provider. Essentially, they are not on the same level. If there is a specific department, it will be directed to the provider.
For example, I have departments A, B, C, D, and E. Department E, in general, is further broken down into providers.
Would the CASE WHEN statement above be possible to use as a dynamic filter 'PRODUCT' with the settings shown in the image?