I have a line+bar chart which has 3 series of data, with one line and two bars. What I observed is:
Clicking the dot on the line only filters with the series value, ignoring the x-axis value.
Clicking the bar does filter with both series value and x-axis value normally.
If I change the chart type to Multi-line, then any line filters with only the series value as well, ignoring the x-axis value.
If I change the chart type to stacked-bar chart, then any bar filters with both series value and x-axis value successfully.
My question is, why the line in the above chart types can not filter with both series value and x-axis value at the same time, while the bar can?
Is there any way to make it work?