Dynamic Filter

Hi friends , Today I'm showing you very interesting dynamic filter where we can change out filter parameter dynamically.

Step1:  Create a "Variable Prompt" type dashboard prompt and give the prompt name,some static values(here is "One' and "Two")

Step 2: 

Select filter for Product type

Edit the filter formula and click OK.

case when '@{filtervariable}'='One' then "Products"."P2  Product Type" end

Add Filter value and OK.

Add the prompt and Report in your Dashboard-

Run the report and Enjoy-