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.
“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
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.
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.