I have created a dashboard that has 5 different charts (1 bar chart, 1 map and 3 pie charts) on top and 1 drilldown table underneath. Initially, this dashboard only shows the top -5 charts (1 bar chart, 1 map and 3 pie charts), and the drill down table is hidden.
In our requirements, the user would like to only have the top-5 charts show up and the drill down table hidden when initially load this dashboard. When the user clicks on any of the top 5 charts in any order, they would like to see the correct detail information in the drill down table. The drill down table will not show when nothing is selected. When the user clicks on any of the top 5 charts (even when 1 chart is clicked), the drill down table is expected to show up. The top-5 charts should also interact with each other. There should be only ONE “visible” drilldown table allowed, and the top-5 charts should control the same “visible” drill down table. The top-5 charts should also control each other (The top-5 charts should interact with each other).
For example, when click on the Jun 2018 bar, then the map and the 3 pie charts should change and only show the data of Jun 2018, and the drill down table should show up and has detail information of June 2018.
For now, the problem I am having is, there is no drilldown table show up when click on the Jun 2018 bar. Only if all the 5 charts are actively clicked, the drill down table show up. The user want to see the drill down table when any of the bar, map or pie charts is/are clicked. So the actions of this dashboard do not function as what we expect.
I have attached the workbooks (one version in v2018.2 and one version in v10.5) and our sample data (Excel).
Any help is much appreciated. Thank you very much