Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
Solved! Go to Solution.
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.
Proud to be a Super User!
Paul on Linkedin.
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.
Proud to be a Super User!
Paul on Linkedin.
Amazing answer, I cannot believe this feature is so limited and buggy. shambles