Good afternoon I am trying to create a panel where I show a normal table with data. The issue that I am having is that I have included two filter fields. One is already set to an speficif value (Field1 = Company1) and the other (Field2) is placed also in the top side of the panel to let the user p…

You can cascade two filters. If you have one filter that chooses Company (1,2,3 etc.) you can set the second filter to only show relevant values based on the first filter. Edit your second filter, choose “Control Options” and choose “Show Relevant Values Only”. You can then choose the Company filt…

Hello First of all thanks a lot for the reply. It makes totally sense and I did not realize about the “related values” option it is present in the properties of the control. This solution works fine, however as you say the problem is that we can not predefine the Filter1, and user can change the s…

Limiting values in filter fields in top panel

Q&A

aswilson February 27, 2024, 5:51pm 4

Hi J, sorry for the slow reply. Here’s a link to the solution I came up with: Auto-set parameter value based on cascading control
You’ll find it at the bottom of the thread. Hope it works for you.

Topic		Replies	Views
Connecting two filters together to filter the contents of one filter Q&A analysis , filters , parameters , database , quick-sight , filters-controls-and-parameters , visual , Business-Intelligence-Engineer	5	906	May 3, 2024
Setting cascading filtering with field filtered on parameter Q&A feature-request , quick-sight , filters-controls-and-parameters	4	493	March 24, 2023
Apply Parameter/Filter to calculated field Q&A formatting , quick-sight , filters-controls-and-parameters , calculations	4	273	June 12, 2023
Restrict list of values in control dropdown using parameter Q&A developer , embedding , quick-sight	6	186	January 28, 2025
Filter data based on one control only Q&A filters , quick-sight , Business-Intelligence-Engineer	4	71	May 22, 2025

Limiting values in filter fields in top panel

Related topics