Set up X-Axis constant line based on slicer value

[cliu822]

Hi everyone,

I have a line chart now, the X-axis is date, y-axix is some value.

This chart is filtered by a slicer called country containing the value "A County" and "B Country". Now I would like to add a X-Axis constant line, when the chart is filtered by "A County", then it shows the date "2022-01-01", when it is filtred by the "B Country", it shows the date value "2022-12-01". I know we should use fx for this, but somehow there is no field value I can select.

Thanks!

[rlsmith1994]

Following