You can try adding a 'Filter Action' to the dashboard.
Dashboard > Actions > Add Action > Filter
Other way to introduce Filter action is > In the dashboard click on first sheet menu (top right side, downward arrow) choose "Use as filter". Then ensure that in the second sheet menu> "Ignore Filter" is NOT selected.
Hope it helps.
This worked great, thank you! I am a new user to the software and truly appreciate your help. It did exactly what I was looking for.