Forum Discussion
Vertical Line Reference to another table with multiple dates
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...
amitchandak
Super User
Super Useramcgrail , If you have a continuous axis, You can use X-axis constant line, there using fx you can use a measure
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
