Forum Discussion
Helper IIHow 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 to every data point of a month.
Im not sure how to do that. Can anyone help?
8 Replies
- ddpl
Solution Sage
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
imagauthamddpl 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
CorneGeyserHelper I
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.
- ddpl
- imagautham
ddpl Thanks for the response.
But I'm unable to find vertical option under Gridlines in my visualization.
- ddpl
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.
