Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Tobias106
Helper I
Helper I

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

1 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

View solution in original post

5 REPLIES 5
amitchandak
Super User
Super User

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

@Tobias106 , I see the option in line stacked visual

 

amitchandak_1-1667567744008.png

 

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

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.