Forum Discussion
Help / Support - Bar+Line Chart with multiple lines
Hi Community,
I have an interesting challenge that has probably happened to most of the developers.
Here's what I want to achieve and the issues that I am encountering, while doing it:
1) I am building a visual where my Bar+Line chart should present as in the attached image (See below). These categories are in the same table, and my customer built this in excel, using 3 of the fields to build the line series.
2) What I have tried so far:
Created a group to isolate these 3 line measures, then filtered the visual (to remove these from the columns and have them only in lines). Issue is that the moment I filter the visual, they are also removed from the line series.
Created 3 different measures to isolate them from the original field ((to remove these from the columns and have them only in lines). Issue is that the moment I filter the visual, they are also removed from the line series.
Can anyone please help me? I spent a day trying so many different options. I have checked other articles here and videos, but none are similar to what I need to achieve.
Thank you so much!
Nelson
10 Replies
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!