Aligning both lines - Line Y axis in a Line and Clustered bar chart

[Anonymous]

Hello everyone!

Is it possible to align both lines of the line Y axis?

In the following example I need to align both lines (the orange one and the green one (which is barely seen at the bottom of each column)). The problem is: the green one is in a scale from 1 to 20 and the orange one is in tens of thousands. They're both a single value per date. I've tried overlaying another visual containing only the line I need but it doesn't align with the bar columns, I also tried upscaling the values but it didn't work out very well due to formatting. I kinda ran out of ideas, does anyone have an idea or tutorial that can solve this problem?

Thanks in advance!

[vicky_]

You can try manually setting the range for the lines - go into Format Visual > Y-Axis / Secondary Y-Axis and then set min and max numbers there (you can click fx and use a measure so that it is somewhat dynamic)