Dataset fields in a dropdown menu

How can I have a dropdown menu on my dashboard that can select which type of location parameter to show in a table that is connected to it?

Users can choose if they want to see the average per amazon region, city, or state, and these 3 are the columns in the dataset

Screenshot 2024-07-15 at 1.49.43 PM

Hi @limgrace ,

You can do this is in a few steps.
Step 1: configure a parameter with the field alias , can be different from exact field names
Step 2: Add the parameter as a drop down menu in the dashboard
Step 3: create a calculated field to return the conditional field. E.g. ifelse($parameter=“value1”, {field 1}, …)
Step 4: Instead of adding respective field dimension to visuals, add the newly created dimension in the visuals.

Hope this helps!

Thanks,
Prantika

Hi @limgrace, did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!