Skip to main content
cancel
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

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
Fabcon_Europe_Social_Bogo

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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.