This is definitely possible. What you would do is create both worksheets the way you would like and structure them on your dashboard.
From there you are going to create an action that will allow your map to act as the filter to select the data you would like to see below.
Dashboard -> Actions
In the Source Sheets, select just your map sheet and run action on "Select"
In the Target Sheets, select just the sheets you would like to see once you click on the map. On "Clearing the selection will:" select "Exclude all values".
I have attached a sample workbook.
test.twbx 531.3 KB
For the most part this does answer my question but unfortunately it doesn't achieve precisely what I wanted it to do.
Before selecting any particular state, I would like the second sheet to be non-visable on the dashboard meaning I want it to not take up any real estate, once I click on a state, I want the first sheet to automatically resize itself so that the second sheet is visible on the dashboard, then once I deselect a state I want it to go back to its original size (with only the map on it)
So the way I envision it is:
No selection: Just the map of the Country with information by state.
with a selection: I want the map at the top and a view to appear at the bottom giving me top 10 products sold or whatever the case may be.
I hope this was more clear.
1 of 1 people found this helpful
The one key thing I neglected in the instructions was to click on a state twice to see the selection and then to "hide" it again. That would give you a view of just the map so you could publish.
I see what you're trying to do. Unfortunately, I'm not aware of how to have the sizes of each sheet dynamically change when on the dashboard. The only solution I could think of was to lay them both out with a set size for each sheet on the dashboard and create the action. I tried using containers but that didn't work either.