Control shows All when there is only 1 option available

[NJK90]

Hello,

I am having an issue with controls that when they have only one value it keeps giving me ‘All’. Is there anyway to get around this? It is a single select control and the user that sees the information only has 1 available option to select, however it says All in the dropdown. I have my control linked to a dataset and there are too many options to use the workaround with ‘Specific Fields’ to exclude All. Next to this I want to work with dynamic defaults when there multiple options to choose from. How to set the dynamic default value in the drop down filter? If a user logs in and has access to 3 options, the drop down should show one of the value as default value of the drop down (instead of all). How do I achieve this?

Any help is appreciated

[Brett]

Hi @NJK90,
Do you have the control setup as a parameter or did you just add a control for a filter?

To remove the ‘All’ option, you can go to edit your control and then check off the box shown below.

If it is set up as a parameter, you’ll want to make sure that you’ve set a default value so that it does not default to ‘All’.
To my understanding, dynamic defaults in terms of parameters can only be utilized with RLS setup. You can check out the article listed below for additional information.

Creating parameter defaults in Amazon QuickSight - Amazon QuickSight

Let us know if you have any additional questions.

[NJK90]

Hi, i’ll try this when I have default values available. This is another question I had but i’ll let you know if I was succesful.

Dynamic parameter defaults

Hello, We use Quicksight with an embed on our React page. Users log on to our enviroment and are able to use QS dashboarding here. We do work with RLS in our datasets. I am trying to achieve dynamic parameter defaults however I do not seem to get user information when users log on to our React page. I am trying to figure out what is necessary to get the information back to QS so I can build a dataset with usernames and their default values. These users do not have a QS login so I can’t get thi…

[Brett]

Hi @NJK90,
Following up here as it’s been awhile since we last heard from you on this thread, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

[Brett]

Hi @NJK90,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!