How to Add an vertical line on the Line chart?

[imagautham]

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 to every data point of a month. 

Im not sure how to do that. Can anyone help?

[mark_timmis]

Hello

You've probably worked it out now but you can only add vertical gridlines if the x-axis variable is numeric. I see yours are month names, which was the same requirement as me when I discovered this.

[ddpl]

@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

[CorneGeyser]

Everybody might have found a work around to this now, but in recent updates Power BI has added a reference line option.

Add a new line, choose the X-Axis Constant Line and then create a measure that will move with a value on your x-axis. In my case I used today's date as my value.

[imagautham]

@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

[ddpl]

@imagautham try this

[imagautham]

@ddpl  Thanks for the response.

But I'm unable to find vertical option under Gridlines in my visualization.

[ddpl]

@imagautham change the X axis  category as per below then check

[imagautham]

@ddpl  I get that when I add like the way you suggested. But When I drill down into month level, The vertical option is disabled