cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cliu822
New Member

Set up X-Axis constant line based on slicer value

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!

0 REPLIES 0

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors