You just want to navigate to next dashboard when you click on something on the first dashboard right?
Here I have superstore workbook, when I click on a particular State my action should take me to "Customer" dashboard and filter customers belonging to selected "State"
Then Create the Action Filter,
Select Source and Target Sheets and views.
Now I click on a State (Oregon in my example) and it takes me to Customer dashboard and filters all the views to customers belonging to my Oregon.
Hope this helps. Attached workbook.
Actions.twbx 634.5 KB
If you need to switch between sheets using the filter, then you will need to lookup how to do a sheet swap with a filter. If you really want to go from one workbook to another, then you will need a URL Action. I seriously doubt that you want to do this. Look into the sheet swapping if the action has to be on the filter. A much easier thing to do is filter the current worksheet and then click on it to move to another sheet with this same filtering in place.