Forum Discussion
Line and Stacked column chart issue
Hello,
I have two charts, one is a stacked column chart, the other is a Line and Stacked column chart. Both use the same excel data table.
The line in the chart is the issue. When I click the stage in the Line and Stacked column chart, it shows the same total percentage not the stage. Even though, when I click the other chart, it shows the correct percentage.
The percentage shown in the line when nothing is clicked shows the total ECL% per scenario, if I click a stage in a sencario, it shows the ECL% of the stage in the stenario. Each Senario has 3 stages.
How the charts look if nothing is clicked.
Below shows the percentage correctly when I click the stage in the top chart.
Below the percentage is incorrect "nothing happens", if I clicked stage in the bottom chart?
Hope its clear. Can anyone help in explaining what might be the issue? how to solve it?
Thank You,
5 Replies
Othman , Not very clear. But can you check interactions. Are you looking for fill(highlight) or filter
I want the line "ECL%" to show the percentage per stage when I click the stage in each scenario. Now, whatever I click in a scenario nothing happens. But If I clicked from the other charts it moves and show the correct ECL% per stage that was clicked. Sorry its not easy to explain, hope this makes it clear.
Hi, Othman
As mention by amitchandak ,please check the visual interactions between these two visuals first.
Change the interaction behavior
Best Regards,
Community Support Team _ Eason
The problem is the data is from the same chart, it works if clicked on the other chart. But the chart itself wont?
Hi, Othman
Disabling one side interactive filtering of visuals may also cause this problem, even if their data comes from the same table.
Please share a sample file for further research.
Best Regards,
Community Support Team _ Eason
