Forum Discussion
Responsive Residentvertical line in Line Chart
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.
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
Responsive ResidentI am not looking for a constant line but similar like this.
Every month
IrwanSuper User
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
