Forum Discussion

imagautham's avatar
imagautham
Icon for Helper II rankHelper II
4 years ago

How to Add an vertical line on the Line chart?

Hi All,   I'm an newbie to Power BI. I have the following requirement In the below Line chart, in X axis we have month name and Y axis we have total Sales measure. I have to add a vertical line t...
Need Help
Show and Tell
Tips and Tricks
ddpl's avatar
ddpl
Icon for Solution Sage rankSolution Sage
4 years ago

imagautham try below combo chart

 

 

Note: drop the column under Line y axis which you have added under Y axis as per below

 

and increase the column tranperancy as per below

 

imagautham's avatar
imagautham
Icon for Helper II rankHelper II
4 years ago

ddpl  I tried this. But this is not enough to make it a thin line.

I found a way to do this. There is an Error bars option in Analytics pane through which I created 2 measures.

One for Lower Bound which i assigned value as 0

Then another measure for upper bound and assigned value as 15000 (which is according to my data)

Then I added these measures into Lower and Upper bound under Error bars.

Then I got the vertical line