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

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


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.




graph2.pngHave you some idea to create this?


Thank you,


Microsoft Employee
Microsoft Employee

Hi @matteocarnelos,


Seems the Analytics line could help.



Best Regards,



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.


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

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 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