Add a second line to a bar and line chart

[Syndicate_Admin]

Hello! I wanted to know if you can help me with the following:

I have a graph of columns and lines, where one represents a quantity and the other an average, what I need is to add a second horizontal line that would have a fixed value and would be the limit that the average line can reach.
Something like this:

Thanks a lot.
Best regards.

[v-kkf-msft]

Hi @Syndicate_Admin ,

Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[Hariharan_R]

Yes. Average line in Analytics Pane will help you to display overall average.

Thanks

Hari

[v-kkf-msft]

Hi @Syndicate_Admin ,

You can only use the constant line from the Analytics pane for this visual if the x-axis is the date/number format. According to your screenshot, your x-axis field is in text format, so I think you had to create a measure, like this:

Measure = 10

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VahidDM · Accepted solution]

Hi @Syndicate_Admin  marcoms

Check these links, and you can find the solution:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane

https://community.powerbi.com/t5/Desktop/I-would-like-to-create-a-bar-graph-with-a-target-line/m-p/9...

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/