1 of 1 people found this helpful
What you're wanting is dynamic parameters, which a lot of people want. As of right now it's not something we have available to us.
However, your situation seems to be one that may not require each of those selections to be a parameter. It seems that, based on what a user selects in the first parameter, you already know the values that need to be filtered. If that's the case, then here is an approach I use frequently to make a single parameter selection impact multiple filters.
1) Create your parameter (let's call it "parameter_selection")
2) Create a calculated field (we'll call it "dynamic_filter") that uses either case logic or if/then logic to define outcomes based on the value in "parameter_selection". That may look like this...
WHEN "hungry" THEN
WHEN "thirsty" THEN
WHEN "sleepy" THEN
For this to work, you would need dimensional fields such as [food_menu], [drink_menu], and [places_to_sleep] existing in your data.
The way this would work is that if I selected "hungry" as the value for [parameter_selection], then the formula we created above for "dynamic_filter" would output the items within our [food_menu] field.
Maybe that field has things like "burger", "salad", "falafel", etc. that now populate a quick filter on my dashboard.
If you select a different parameter option, the quick filter's options will be replaced by the values of another field entirely.
It isn't a dynamic parameter, but it can achieve many of the things you might want a dynamic parameter to achieve in the sense that it dynamically swaps out the lists of options available to your users.
Hope that helps!
I have the same Idea but Tableau can't do in this time. I hope Tableau can give parameter more powerful
Thanks for your quick response Elliott Stam! I will give your secondary option a try to see if I can apply it to our needs. Appreciate the help!