I am not aware of an option to define the line types on the graph on Tableau. Hopefully some of the experts on this forum can help us with that.
In the meanwhile, I have changed the solution approach to add new calculated fields for Current Year and Previous Year and used a parameter to show this control. See the attached workbook. Would this help?
Thanks Siraj. Unfortunately, i'm tasked to replicate as close to the powerpoint chart as possible. But your dual-axis suggestion will at least provide me with an alternative option. Thanks!
Thanks Alex. Guess aside from the inability to produce the dotted line graph, this is by far the closest possible.:) Thank you