Forum Discussion

Tobias106's avatar
Tobias106
Icon for Helper I rankHelper I
3 years ago
Solved

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

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

Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    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