Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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!

1 REPLY 1
rlsmith1994
Helper II
Helper II

Following

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors