Hello, you need to click on the magnifying glass in the spreadsheet to use a dashboard filter, also, keep in mind that changes made to the spreadsheet will not reflect on the dashboard.

When you create a dashboard it makes a copy of the spreadsheet, so if any changes were to be made on the dashboard, you would have to edit the related json from the dashboard app settings instead of the spreadsheet in documents.

I hope to have answered your question.