I want to set a multi-row parameter by selecting the associated “friendly name”. Using cascading controls and a utility table that associates a friendly name to the multiple category IDs that are valid. In the parent control I can select “some friendly category name” and it sets the matching child …

This was resolved using a calculated field to add a row to the dataset with the designated season based on code.

Hi, Checkout this may help you. [image] Cascading Filters and Dashboard Embedding- from on sheet to background connection for cascade Question & Answer Friends, we are running into an issue on Cascading Filters. The problem statement and details are below: if there is a…

Thank you for the reply Naveed. I don’t think that thread solves my issue. Imagine the dataset below powering my controls. I need to filter the dataset on a multi-value parameter that contains the codes that match the season. If I choose “Spring” the parameter should be set to 121, 130, 149, 150. …

Thanks for letting us know @aswilson !

@aswilson Hi I am facing a similar issue, could you please elaborate on what calculated field did you use

With the above example, I created a calculated field called season with a formula like: elseif(locate('121, 130, 149, 150', {code})>0, 'Spring', locate('320, 345, 346, 375', {code})>0, 'Winter', locate('218, 236, 242, 289', {code})>0, 'Summer', locate('412, 413, 440, 451', {code})>0, 'Fall', NULL) …

Auto-set parameter value based on cascading control

Q&A

Naveed February 14, 2023, 6:48am 2

Hi,

Checkout this may help you.

regards,
Naveed Ali

Topic		Replies	Views
Setting cascading filtering with field filtered on parameter Q&A feature-request , quick-sight , filters-controls-and-parameters	4	493	March 24, 2023
Filter data based on one control only Q&A filters , quick-sight , Business-Intelligence-Engineer	4	71	May 22, 2025
Show relevant values only in parameter control isn't working when used in filters Q&A analysis , filters , parameters , feature-request , quick-sight , calculations	4	1913	October 16, 2022
Dynamic Parameter selection Q&A parameters , quick-sight , filters-controls-and-parameters , Business-Intelligence-Engineer	9	260	January 5, 2024
Create a Parameter Dropdown that matches a filtered variable in a table Q&A quick-sight , filters-controls-and-parameters , Business-Intelligence-Engineer , tables	5	70	March 31, 2025

Auto-set parameter value based on cascading control

Related topics