I have used the Superstore data to recreate a dashboard from my environment in which I would like to see the Top 5 states by sales for all regions, which is not an issue. However, I would like to see the top 5 states for each region selected on the dashboard. I have set that worksheet is acting as a filter for the dashboard.
What I end up with instead is: I select a single region, I only see a couple of states. I know this is because the states are filtered down to 5, and if a couple of those 5 states happen to be in that region, they display.
I am not sure how to have the top 5 for each state display for all regions, and then for each region (or several regions, if I select more than one).