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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ludovic_ott
Regular Visitor

Need a visual with goal line on combo charts

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.

 

ludovic_ott_0-1698340152447.png

 

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

 

Thank you.

 

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @ludovic_ott ,

 

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

 

vyangliumsft_0-1698647823361.png

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])

vyangliumsft_2-1698647898074.png

 

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.

View solution in original post

4 REPLIES 4
v-yangliu-msft
Community Support
Community Support

Hi  @ludovic_ott ,

 

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

 

vyangliumsft_0-1698647823361.png

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])

vyangliumsft_2-1698647898074.png

 

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.

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

ludovic_ott
Regular Visitor

 

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

 

ludovic_ott_1-1698341219719.png

 

 

anilkapkoti
Helper II
Helper II

Hi @ludovic_ott ,

Please Refer to the below Screenshot.

anilkapkoti_0-1698340906179.png

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.