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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
matteocarnelos
Frequent Visitor

Graph chart with reference line

 

 

Hi guys,

I'm new in this forum and I hope to have posted in the right section.

So, in my situation I've 12 values of lead time of 10 articles (one value for month for each article), and for each article I've an ideal lead time (see next image).

DataBaseDataBase

I would to create a line chart to monitor the trend: putting in the x axis the months, the values are the lead time, in the legend there are the articles (so, a line for each article), and I would also to show the horizontal line with the ideal lead time for each article.

I know that in other software there is the possibility to do this, but the ideal lead time is only shown selecting each article, also this can be a solution in my situation.

I try to explain better with the follow images.

  

graph1.PNG

 

graph2.pngHave you some idea to create this?

 

Thank you,

Matteo

2 REPLIES 2
v-jiascu-msft
Microsoft Employee
Microsoft Employee

Hi @matteocarnelos,

 

Seems the Analytics line could help.

Graph_chart_with_reference_line

 

Best Regards,

Dale

 

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

thanks for the reply, but this solution isn't work in my situation: because I can't insert a value by keyboard, but I've to insert the values that are in a column in another table in the database, and these values are different for each element.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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