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!