Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

Need help for my Line target in my line chart

Hi All,

I Need help on my current project to duplicate the line graph in excel into Power BI chart. I'm having a problem on how to do the target line on power BI. I hope that you will help us on this, Thanks in advance....


This is the Excel file, the line orange is the OTD Target% and has the value for 2023 = 95% and 2024 =98%



This my Power BI desktop Output my target line (orange) seems to be straight and I want to duplicae the output in excel.


Super User
Super User


I cannot understand anything from those screenshots.  Share the download link of the PBI file and show the expected result clearly.

Ashish Mathur

@Ashish_Mathur sorry, how to attached my power BI desktop here? im new to this site. Thanks

Regular Visitor

Hi @MFelix ,


Thanks for the reply, I used dax measure in the refference line (Y-Axis Constant Line) but doesn't work, maybe can u check and help me to inject the right dax.

Please attcehd file.


Thanks in Advance....


OTD Target % = AVERAGE('sample'[OTD target])




Hi @Mark45 ,


The issue is that since you are adding a trending line the month is taken out of context and it's consider for the full period so instead of getting a value per each of the month you get the average for the full period considered in the chartt in this case 95.4%.

Since you are using a line chart add your measure has another line ( you can do it on main axis or secondary axis) and format has a dotted line:




Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português

Super User
Super User

Hi @Mark45 ,


How are you getting that value to the chart? is it based on a value for each month? A calculated measure?


Can you please share same more insights on how you have your data model and the chart setup.


Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors