Hi,
I have a dashboard filtered by “account_name,” and I want to add a control to enable users to filter based on “policy_name.”
I tried adding a control from a filter and from a parameter linked to the policy_name field; the problem is the control has a NULL option at the top which I don’t want users to see:
I’m not sure where it comes from because when I filter the dashboard to see the data of “NULL” policies- all the visuals are empty.
Also, applying a custom filter list with “exclude nulls” doesn’t affect it.
It seems like a default that is added to the dropdown control like “select all” - only without the option to remove it.
Using “specific values” for the control is not an option since each account might have different values in the policy_name field.
Hi @Yuval.Shiboli,
When setting up a parameter, did you leave the ‘default value’ option blank or is the ‘reserved value’ option set to ‘NULL’? Normally these are the two potential reasons on why ‘NULL’ would populate in your dropdown. I suggest setting a default value to your parameter and that should remove the NULL option.
I tried leaving the default static value empty or setting it to “All” - it didn’t make any difference.
The ‘reserved value’ option is set to “Recommended value”
Add the filter to your sheet. Set the relevant values for your control based on the filter which is on your sheet and that will remove NULL from the dropdown list.
Then, hide the filter which is on your sheet by moving it behind a visual in free-form layout.
