Align axis in Line chart

[Anonymous]

In the below Line chart visual in screen shot 1, Sales Target is drifting too high driven by its numbers compared to Current and Prior and causing too much variation in the chart, is there a way to minimize by bringing Sales Target around middle of the chart dynamically.

Screen shot 1 (with Current, Prior and Sales Target):

Screen shot 2 (without Sales Target): 

Screen shot 3 (Format):

[Anonymous · Accepted solution]

Hello @negi007 ,

I greatly appreciate your time into looking into this and i found a solution which looks like the following which I was expecting.

Line Chart:

I moved Prior from Secondary values to Values as per below screen shot.

Format:

and then by changing Format Pane ->Secondary Y axis->End = function as Median of Sales Target

[negi007]

@Anonymous However, this visual will given an impression that target has been achived which is not the case. in such cases, it is not advisable to use target in the secondary axis as both actual and target measurement unit are same. But it is upto you how you present and explain it to your audience. cheers!!!

[negi007]

@Anonymous in this case , you can try logarithm scale like below. change the y-axis like below

i hope this helps you