Still relatively new to QuickSight, I am having issues with getting a text filter to default to “none” and stay that way when doing a reset on it’s corresponding control. I have a dataset with potentially tens (or hundreds) of thousands hostname values. My Analysis visuals are trying to show details and summarized information about one of those at a time - user selectable using the control. I can’t find an exact match question and answer so I apologize if this is a repeat and my search techniques are just not honed to find what I want …
I wish to default the filter to showing “none” so the initial view of the dashboard will have all visuals giving “no data found” results. Then a user can search, select, and change to their desired hostname value to refresh the visuals to show that specific host’s information.
If they “reset” the Control on the sheet, it should again go back to the default of “none” …
I seem to keep getting a default of “All” with everything I have tried.
Anybody have a set of filter settings, controls, and proper steps needed to get this accomplished?
Thanks, in advance.
Hi @jnkline
In the parameter you can supply a default value. This will be the value selected as you get into the dashboard and when you reset it will reset to this default.
If your parameter is multi-value you can supply multiple values as well as default. I have a case where I have a parameter task type; I want all except “Break” to be selected by default. So I listed all the task types excluding Break in the default field and that is what is the default selection when I get into my dashboard.
Hope this helps.
Regards,
Giri
1 Like
@Giridhar.Prabhu thank you for the reply. I am not using parameters, just created a filter for the dataset field and created a control at the top of the sheet. With your suggestion that I need to create a parameter and set the default (assuming I leave it empty as the yellow highlight in your example) - I guess I need that little push in the right direction as my original post asked for - example steps of how to create the right control that will default to nothing, allow a dashboard user to select ONE host from the dropdown list, and be able to quickly get back to nothingness if/when they want to. I started trying to add a parameter, but I think I am adding confusion to my dashboard with the current Filter controls and then parameter controls at the same time …