Dropdown filter with an Unselect value as default

Hello, I want, as default, to have one value unselected on the drop down filter.

I tried to publish it with the value unselected, but it didn’t work. It defaults to ‘All’.

I could use the ‘Static multiple default values’ on the Parameter. However I want to keep it dynamic and not a static x-1 default values. Is there another way?

If my question is not understandable, I can try to rephrase it. Thanks!

Hello @rmdcunha , welcome to the Quick Sight community!

I do not believe there is a way to set a multi-value default using a drop down control. I’m assuming, retaining the ability to have the excluded value as an option to be filtered by the QS user is important.

There is probably a work around though. What is the main goal/use case that you are looking to accomplish? From what you’ve said it sounds like users should be able to see all other values initially and then be able to add in that final value later.

Hello @duncan, thanks!

“I’m assuming, retaining the ability to have the excluded value as an option to be filtered by the QS user is important.” - You understood correctly :slight_smile:

I have a pivot table and let’s assume each drop down value matches one column (in reality it doesn’t, but to simplify). The goal is to have this column hidden by default to the QS user.

1 Like

Hello @rmdcunha !

I actually did more testing and figured this out in a way that I believe works for your use case:
Multi-value default

Depending on how many values you have it may be tedious but essentially you just use the “multi-value default” when creating a string parameter and exclude the value that you want hidden in your pivot table.

Then when you create your control, make sure that all values from the field are present including the value you want to exclude. Also, be sure to check the box that says “Hide select all option…”.

Next just apply your parameter control to your filter.

Let me know if this helps!

Hello @duncan

Thanks for your support! I will try to replicate your solution :slight_smile:

Question regarding your solution, as I have the control associated to a Parameter Linked to a Dataset Field.

When this dataset field adds more values, will I have to edit the “multi_value default” and also add these new values?

1 Like

Hello @rmdcunha!

Yes, to make this solution work you won’t be able to use the ‘link to dataset’ option. You will have to manually update the control options.