I have a workbook with a header across the top of a sheet. I use the header as a filter for the other sheets on the dashboard. This header allows the user to quickly filter the sheets on the dashboard according to their selection. I would like to know if there is a way to retain the non-selected values in the view when defining the filter's value in a URL.
My basic URL is:
This works to load the dashboard with the filter already applied, however, it excludes the other values in the header.
Without having a look at your workbook, I'm not sure whether this works for you or not.
Please check the settings of the filter in the header, and select "All values in database".