Forum Discussion
X Axis constant Line
Here you can see the link and response from NaveenGandhi
Hello, tharunkumarRTK ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hi,ParsaOmidvar .I am glad to help you.
I agree with tharunkumarRTK 's suggestion.
If you add a Constant line with an incorrect data type. You can try to create a measure with the same calculated effect and set the correct data type for it and add it as the value of the Constant line in the visual
Like this:
You need to make the data type of measure consistent with the X-axis field type
The constant lines added are related to the data types of the X-axis and Y-axis fields.
I hope you find the following related article helpful.
URL:
Add a Constant Line to a Line and Clustered Column Chart in Power BI
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your time, but it was way more complicated than this, I read a post which used error bars to dinamically creates vertical lines in a visual when specific criteria met.