Follow below steps:
1. Create required dashboard.
2. Add a floating button the dashboard.
3. Edit the button and select the target sheet to navigate.
4. Now the sheet that you want to use as a filter, add the filter from edit action dialog box and select the fields to affect in worksheet/dashboard.
5. Now select/click on a sheet as a filter and click on button to navigate to page and observe the changes.
Hope this helps you.