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):
@Babulal 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!!!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos