Need a visual with goal line on combo charts

[Anonymous]

Hello,

I am looking for a visual that would allow me to add a goal line for the data represented by the column chart. I am currently using a "Line and clustered column chart" with a secondary y-axis, but there is no option to add a goal line under the "Analytics" section.

Is there another visual out there that I can download that would allow me to do that? 

Thank you.

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

According to the official documentation restrictions, line and clustered column charts cannot apply dynamic lines.

Refer to:

Use the Analytics pane in Power BI Desktop - Power BI | Microsoft Learn

You might consider turning Secondary y-axis on at line and clustered column charts - Format, after which you can create the measure associated with dynamic lines and place it inside to form a folded line:

Measure =
AVERAGEX(ALL('Table'),[Value])

Best Regards,

Liu Yang

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

[Anonymous]

Hello, I did something similar and it worked, thank you. 

[Anonymous]

As I mentioned initially, I am using a "Line and clustered column chart", and there is no option like this in the "Analytics" section :

[Anonymous]

Hi @Anonymous ,

Please Refer to the below Screenshot.