Line and Stacked column chart issue

[Othman]

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,

[Othman]

The problem is the data is from the same chart, it works if clicked on the other chart. But the chart itself wont?

[v-easonf-msft]

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

[amitchandak]

@Othman , Not very clear. But can you check interactions. Are you looking for fill(highlight) or filter

[Othman]

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.

[v-easonf-msft]

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