vertical line in Line Chart

[ashmitp869]

Hi ,

How to add vertical line in Line Chart.

[v-nmadadi-msft]

Hi @ashmitp869 ,

We have not heard back from you if any answer has met your requirement kindly  Accept it as the solution  to help out other community members.

Thank you

[v-nmadadi-msft]

Hi @ashmitp869 ,
Thank you for reaching out to Microsoft community support.

You can find X-Axis Constant Line and Y-Axis Constant Line in Visualizations – Analytics.

This feature will be available to numeric and date data types, but wont be available to text data type. We can transform text type to date type if possible to add constant lines but if that is not possible check the below steps.

If you want to add a vertical line in a line chart, we don’t have a direct feature to do so for Text values but there is a good enough work around to do for your desired task.

-> Click on the Insert pane and click on shapes.

->From there select the line chart

->Click on the line chart and use format visual to rotate the line 90 degrees, we will obtain a vertical line.

-> The resulting line is shown in the below picture

->Please use that shape to overlay over your line chart visual wherever you want, For ex

Please consider Accepting the solution if the provided answer meets your requirement so as to help other users or get back to us if you have further queries.

Thanks and Regards

[ashmitp869]

I am not looking for a constant line but similar like this.

Every month

[Irwan]

hello @ashmitp869 

i might be mistaken but that picture looks like a vertical grid line to me.

Thank you.

[danextian]

That's probably what OP is looking for unless he wants the line to be somewhere specific.

[ashmitp869]

Wondering if you can help me to achieve the green lines.

Providing a sample file.

https://github.com/suvechha/samplepbi/blob/main/sample_b.pbix

Currently it looks like 

[v-nmadadi-msft · Accepted solution]

You can add multiple constant lines referencing the dates that you want.

But you are not able to view the X axis constant line because your data type may be in string format please transform the data into date format or numeric format, then you will be able to view the x axis constant line. This will resolve your issue and you will be able to constant lines as required.
Thanks and regards.

[danextian]

If you want the lines to be somewhere specific then you'll need to add several Y-Axis constant lines

Otherwise, you can enable the vertical gridlines.

[danextian]

Hi @ashmitp869 

Is this what you're looking for?

[ashmitp869]

I am not looking for a constant line but similar like this.

Every month

[danextian]

You will need to add several constant lines to achieve that referring to different dates.

[ashmitp869]

When I am using line chart I don't an options of X Axis Constant line.

When select Line and column stacked chart - don't have the X Axis Constant line.

Any suggestions ?

[Greg_Deckler]

@ashmitp869 The Analytics pane only supports an X-axis constant line if you have a numeric x-axis. Otherwise, you just have to create a line shape and then overlay it. 😞