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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Mark45
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%

Mark45_3-1713317697668.png

 

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

Mark45_2-1713317513080.png

5 REPLIES 5
Ashish_Mathur
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

Mark45
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])

Mark45_3-1713406075279.png

 

 

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:

MFelix_0-1713434879722.png

 





Regards

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



MFelix
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.


Regards

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

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.