Vertical Line Reference to another table with multiple dates

[amcgrail]

I'm trying to create a benchmarking visual that can toggle between different location's metrics while showing a vertical "benchmark" based on another table with all of the benchmark dates.

I have a dataset with different metrics and a date field. I have another table with locationsand a benchmark date. How would I go about building a visual to show metric trending and a benchmark that will toggle between locations when I select a different location?

Let me know if any additional information or context is needed. Thank you!

[amitchandak]

@amcgrail , If you have a continuous axis, You can use X-axis constant line, there using fx you can use a measure

[amcgrail]

That is one part I've been getting stuck on is adding a measure to accurately show the benchmarking dates when selecting a different location. If I had a chart like the one below, what type of measure would I create to insert into the x-axis constant line fx? That way when I select a new location, the benchmark changes on the chart.

Abbreviation	Go Live Date
ABC	3/1/2023
RED	5/1/2021
DEW	7/1/2022
PLS	7/1/2022
ERS	4/1/2020
WWW	10/1/2023
MLS	6/1/2023
YTD	10/1/2023
RSP	10/1/2022
CCS	6/1/2021
PPW	6/1/2023