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...
amcgrail , 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 |