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

  • CorneGeyser's avatar
    CorneGeyser
    Icon for Helper I rankHelper I
    3 years ago

    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.