X Axis constant Line

[ParsaOmidvar]

I want to add X axis Constant Line to Line And Clustered Column Chart, My X axis is Index and stored as String not Numeric or Date Data Type. How Can I Work Around That? 

[Anonymous]

Hi,@ParsaOmidvar .Has your problem been solved?
If you have found suitable solutions, please share them as it will help more users with similar problems.
Or you can mark the valid suggestions provided by other users as solutions.
Thank you very much for your understanding and support of 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

[Anonymous]

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.

[ParsaOmidvar · Accepted solution]

Here you can see the link and response from @NaveenGandhi

https://community.fabric.microsoft.com/t5/Desktop/X-Axis-Constant-Line-Missing-Even-with-Date-Data-T...

[ParsaOmidvar]

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.

[tharunkumarRTK]

@ParsaOmidvar 

If I understand correctly you want to add a constant line to a Line and clustered chart. If yes then you can create a measure which results into a constant value and add that measure into line field of the visual.

Line and clustered support adding a constant or reference line, so I would suggest you to create a meausre and plot that as a line 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!