In my experience with reference lines what you are looking to do is not possible, reference lines are static across the entire data set and not functionally designed to 'jump'. Will gladly bow to the Jedi who may know better on this.
Depending on how your data is structured (sans using the table you referred to) you could add in a calculation to mark the monthly performance goal.
Another option may be to use the table you referenced and either use it in a join fashion or as a separate data source based on a common link like employee name or number.
1 of 1 people found this helpful
I've attached a workbook that describes different examples of how actual vs targets might be visualized in Tableau. Usually a bullet chart is how we achieve this, essentially a bullet chart is a reference band with a reference line auto generated when you use the SHOW ME option in the top right of the viz. You can dissect this if you edit the reference lines in sheet 01, notice how one is a distribution where I set the percent and another a Line that shows the actual Target. Below is a screenshot of the Distribution settings (I added color goals at 75% and 100% of target)
Great solution, will keep this in my back pocket.