It is possible to filter within the chart itself; Ensure your dashboard action is filtered on only 'Store' - and get rid of the highlight filter. See attached example.
I think this is possible by also adding a Worksheet Action. See the instructions below and sample workbook attached.
- Go to the Store worksheet and select the Worksheet > Actions... menu option
- Click Add Action > Filter...
- Set the following Options and click OK. (replace Department in the Target Filters Selected Field with your Store field)
- Click OK to exit the Actions window.
Let me know if this works for you. If you need additional help can you provide a sample packaged workbook to demonstrate the issue and show how your views and actions are set up?
worksheetaction.twbx 1.0 MB
From your workbook example, I see that it works by only having one chart in that one dashboard.
I added another view in the dashboard, and replicated the same action, but now it doesn't work as I wanted it to be.
Compare 'Dashboard 1' and 'Dashboard 2'
Thank you Andy!
1 of 1 people found this helpful
You can add a Filter Worksheet Action to Sheet 2 to get the desired behavior on Dashboard 2. See attached and the screenshot from my previous response.
WOW! It works.
Ok. One more follow up question. What about in Story mode? I just put the dashboard into a story, and now that functionality doesn't work anymore.
Hi Reynaldo, I am not sure, I tried it out is Story mode and couldn't get it to work either.