I have a scatter chart with a bunch of bubbles that represents different business units. By clicking a single bubble (so this is to a specific business unit) I want the scatter chart to be converted into a bar chart showing the products (SKUs) behind this business unit in terms of units sold evolution.
Question: is that possible to "convert" the scatter chart into a bar chart just by clicking into a bubble in the scatter chart ?
You could solve this by creating another Bar Chart with Business Unit as dimension and try to use Show/Hide conditon to enable or desable when you click on bubble on Scatter chart.
You can use GetSelectedCount(BusinessUnit) to find whther the unit has selected or not.
