Could you share your packaged workbook(***.twbx) ? that's much easier start point for people in the community to investigate.
I would love to share my workbook. Unfortunately, it is high confidential and I am not allowed to share.
Nevertheless, can I provide you with more information to get a better understanding on this issue?
Thank you very much that you take your time for me.
You need to amend the dashboard actions.
Clicking on use as filter generates a dashboard action. This can be amended from the dashboard actions menu.
When you go to this section for each action you can select which worksheets trigger the action and which worksheets it effects.
Let me know if you need more help with your actions.
If so please share screen shots of the actions currently in place and I can recommend how to fix these
For each of the filters above remove the source sheet from the target section
so for the first one just untick sales month overview from the target section
Let me know if this fixes the issue for you or if you need any further assistance
Nope.. It did not work. Same issue remain. First selection is correct and when I select a second "Field" in a different chart it gives me a total of the selected chart in all other charts..
I think the problem is that the dashboard does not filter to the already selected 'Field" as described above.
Please let me know if I can provide you with more information/
Not to worry,
Lets start from the beginning.
I can see 3 graphs on your dashboard but 5 actions. (what are names of the sheets on your dashboard?)
now if you can think of the user journeys and map out all possible user journeys
for example user clicks worksheet 1 > filter worksheet 2 & 3 > user clicks on worksheet 2> filter worksheet 3
If you can tell me the different scenarios in the way shown above.
I can let you know if this is possible or you have scenarios where your actions will clash.
If there are no clashes I can show you how to set these up
Kindly note that my dashboard contains 5 worksheets which displays 5 charts (Map and Sales Months Overview not to see on my attached images but to see on my dashboard)
Names of the sheets on the dashboard are:
-Sales Months Overview (worksheet 1)
-Model Mix - Pie Chart (worksheet 2)
-Map (worksheet 3)
-Bar Chart (worksheet 4)
-Engine Mix (worksheet 5)
I cannot write down all possible user journeys because there are too many... For instance:
user clicks worksheet 1 > filter worksheet 2,3,4,5 > user clicks on worksheet 2> filter worksheet 3,4,5> user clicks on worksheet 3> filter worksheet 4,5 user clicks on worksheet 4 > filter worksheet 5
user clicks worksheet 1 > filter worksheet 2,3,4,5 > user clicks on worksheet 3> filter worksheet 2,4,5> user clicks on worksheet 2> filter worksheet 4,5 user clicks on worksheet 4 > filter worksheet 5
user clicks worksheet 1 > filter worksheet 2,3,4,5 > user clicks on worksheet 4> filter worksheet 3,4,5> user clicks on worksheet 5> filter worksheet 2,5 user clicks on worksheet 5 > filter worksheet 2
And so on...
What I had in mind to do is that my dashboard is too 100% dynamic and you can click any worksheet and it will automatically change all other worksheets with the selected "field/filter".
The interesting part is that the first filter process is working but the second filter process output a total of all worksheets again because it does not include the filter I preselected.
If you really need all possible user journeys I will of course do it.
Again thank you that you take your time with me.
The issue you have here is depending on the user journey and what point in their journey they click on a dashboard the filtering should work in parralell to this.
If worksheet 3 was already clicked then worksheet 2 only filters worksheet 4 & 5 else it filters worksheet 3,4&5,
there is no functionality at the moment that I know off that can ful fil this criteria.
The best way to go about this is reduce the number of sheets that need to be filtered.
One way of doing this is to set some sheets to only highlight data and not filter the data.
e.g. Rather than filtering a pie chart why not just highlight the segment of pie chart
Hope this helps you understand the complexities of what you are trying to achieve
If you can tell me which dashboards should filter and which dashboards should highlight I can help you with the actions.
Did you ever find a solution to this problem? I am facing the same problem at the moment, and to me it seems there is a limit of 1 action filter per dashboard (using 10.1 here).
Same here. What steps for a resolution?