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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
karthi_power_bi
Frequent Visitor

X Axis Constant Line is missing

I have a line chart ( which shows Actuals & Forecast) with multipe legends. I would like to draw a vertical line where the forecast start date i.e., from next month onwards.

 

X Axis is having values as "Jan, Feb,Mar,Apr, May,Jun,Jul,Aug,Sep,Oct,Nov,Dec"

 

Y axis is having values as $50M, $100M, $150M

 

Line chart shows data for 3 department's actual and forecast.

 

I need to seggregate the Actuals & Forecast with that vertical line. 

 

1 ACCEPTED SOLUTION
PaulDBrown
Community Champion
Community Champion

Currently the vertical line for the x-axis is only available for numeric axis. There is hack of sorts to keep the vertical line with text axis, but I have only managed to make it work with a clustered column chart. It basically involves starting off with a line chart, adding both the numeric and text fields to the axis (the order seems to be important, so the text above the numerical), adding the vertical line (while the axis displays the numerical values) and then swicthing to a clustered column chart.

setup.jpghack 1.gifhack 2.gif





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

2 REPLIES 2
PaulDBrown
Community Champion
Community Champion

Currently the vertical line for the x-axis is only available for numeric axis. There is hack of sorts to keep the vertical line with text axis, but I have only managed to make it work with a clustered column chart. It basically involves starting off with a line chart, adding both the numeric and text fields to the axis (the order seems to be important, so the text above the numerical), adding the vertical line (while the axis displays the numerical values) and then swicthing to a clustered column chart.

setup.jpghack 1.gifhack 2.gif





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Amazing answer, I cannot believe this feature is so limited and buggy. shambles 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors