I have a lot of fixed dashboard that use the same sheet. On each dashboard, I would like to apply the same filter with distinct values.
Solution 1: Create one sheet for each dashboard (more than 100 sheets), that's insane.
Solution 2: Create one sheet and apply a local filter on each dashboard to filter the exactly value that I want.
It's not clear what you are looking for here.