Line and stacked column chart: Line on y-axis from column?

[Tobias106]

Hello,

I have a Line and stacked column chart:

- X-axis = Date

- 1st Y-axis = Columns with values (Min =0, Max = 80)

- 2nd Y-axis = Lines with values (Min = 0, Max = 600)

Now I want to show a an average line wit the value 10 on the 1st Y-axis.

The 2nd Y-axis doesn't make sense beacause the value 10 is to low in a scale with Max = 600.

Is there any possibility to show the line on the 1st Y-axis?

Thank you.

Tobias

[amitchandak]

@Tobias106 , Use analytics pane, constant line

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

[Tobias106]

@amitchandak This option is not available for my chart...

[amitchandak]

@Tobias106 , I see the option in line stacked visual

[Tobias106]

@amitchandak Interesting, in the german version I don't have this option for this kind of chart...

[v-yueyunzh-msft · Accepted solution]

Hi ,  @Tobias106 

The "Use the Analytics pane in Power BI Desktop" feature in the "Line and stacked column chart" is not avaliable .

This is the limitation for this feature:

Lastly, you can't currently apply any dynamic lines to many visuals, including (but not limited to):

• Funnel
• Line and clustered column chart
• Line and stacked column chart
• Ribbon chart
• Non-Cartesian visuals, such as Donut chart, Gauge, Matrix, Pie chart, and Table

For more information, you can refer to :

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

Best Regards,

Aniya Zhang

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