But with this solution I believe still both dashboards will show same data, I am looking for a dashboard per country.
As the country filter is going to define the country per dashboard I want it to affect only at the dashboard level if possible, so in every dashboard this filter can be different....
Yes, that is what I want to avoid as in the example there are 2 worksheets but in the real dashboard there are a lot ... that would not be convenient so I hope there is a workaround...
Would love to hear any workaround form other folks of this community. But, recently I completed a project where in I followed the same approach as I couldn't find any other alternative.