Forum Discussion
Help / Support - Bar+Line Chart with multiple lines
Hi Anonymous,
I'd like to suggest you use line and stacked column chart to achieve your requirement. It support use legend field and multiple line fields at same time.
Sample:
Regards,
Xiaoxin Sheng
Hi there,
Thank you for the suggestion. That's the one I am using. Perhaps I have not made myself clear as to what is the main issue.
The problem is that the data that I want to show in those lines, are the same field. So the problem is, when I drag the field to the lines and filter to only show that specific attribute, it also filters the columns.
Here's what I want, show the values in line and filter them out in those bars.
In the following example, the blue line corresponds to the red bar volume, how do I filter it and only show the line, considering what I have mentioned above ?
Thank you!!
Kind Regards,
Nelson
And this is what happens when I filter out (only from the bars) the values that I have in lines.
On the right, you can see that I have the measures created and added as line values, but because they refer to the same values as in bars, they get filtered out.
Anyone knows a solution for this ?
Much appreciated!
Hi Anonymous,
It seems like your graph has been filter and line value are too small to display on current y axis.
Unfortunately, current this visual not contains any 'break down' axis features, I'd like to suggest you turn on use secondary to display line graph on another y axis unit to solve this scenario.
Regards,
Xiaoxin Sheng
Hi XiaoXin,
Thanks for your support. In fact, that has helped me to bring my line values to the position where they should. However my main difficulty isn't solved yet.
I bring those line values in, however I cannot filter them out of the bar values :( I have tried a million things... I would really like that someone came into this difficulty and could help me.
Here's how it looks right now: