Dashboard 1: A map showing countries. Clicking on a country will take you to Dashboard 2
Dashboard 2: Detailed information for the selected country. (No problem so far!) However, the user would now like to scroll through all the countries, one by one on Dashboard 2, with the countries listed in a specific order, for example by decreasing sales volume. The Pages shelf would provide this functionality if I put Country on the Pages shelf - but I can't set the Pages shelf to start with the country that the user has selected.
Using a filter action from Dashboard 1 to Dashboard 2 doesn't work either - the user arrives on Dashboard 2 with the selected country showing, but then the Page controls will not work as there is one only country in the filtered dataset.
I could clear the filter by using another filter action on Dashboard 2, set to "Show all values" when the selection is cleared - however, the user would then have to double-click a worksheet in Dashboard 2 to set, then clear the filter.
I'd appreciate any ideas on how to implement this type of dashboard navigation,
I have a feeling this behavior is by design but we may be able to find a workaround if you post a packaged workbook that we can take a look at. If you have sensitive data, I would take a look at Anonymize your Tableau Package Data for Sharing.