Forum Discussion
filter multiple column values in stacked line chart
Hi All,
I have a stacked line chart with multiple column values--meaning multiple measures under the same "column values" box. I have also the month year axis in the "shared axis". My issue is that although the graphs look good, I cannot click on the different stacks (blocks in the column chart) to filter out my data. E.g. in one stacked column, there's the blocks called "Apples" "Pear" Orange". when I click on apples, the WHOLE stacked column is clicked and not just apples. How can I solve this? I understand that I need to add column series but is there also another way?
2 Replies
Anonymous , This what I got. If you click on stack, it filter axis and legend , if click on line then if filter on axis. And that seem correct.
Hi Anonymous,
According to your description, I think they are working as expected.
When you enable multiple axis and legends fields on your chart, those visuals will show the graphs with detailed data labels but the selection is hosted on the parent axis group instead of detailed data labels of legends.
Regards,Xiaoxin Sheng
