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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

How to add average line to measure bar chart

Hi, 

Need help to add an average line to bar chart.

These measures are calculated through CALCULATE and COUNT with FILTER, etc.

C1.PNG

I want to show them in bar chart with and an average line shows across the bars. Like below:

C2.PNG

However, when I use Line and Staked Column Chart and put the TEST to the Line Values, it shows below. Can someone suggest a way to solve.

C4.PNG

 

Thanks in advance.

1 ACCEPTED SOLUTION
MarkS
Resolver IV
Resolver IV

HI @Anonymous,

On the analytics tab of the clustered column visualization you can choose to add an average line.  Select the measure that you want to average from the dropdown for the measure.

Community 12-21-2017.PNG

View solution in original post

5 REPLIES 5
MarkS
Resolver IV
Resolver IV

HI @Anonymous,

On the analytics tab of the clustered column visualization you can choose to add an average line.  Select the measure that you want to average from the dropdown for the measure.

Community 12-21-2017.PNG

What if I need to play with the value to calculate the standard deviation??

Is there a way to "Calculate" that average as a variable?

 

Shelley
Continued Contributor
Continued Contributor

This is awesome! THANK YOU! I couldn't get my measure to work. This gives me what I was looking for. Hopefully, my customers agree.

 

Anonymous
Not applicable

Is there a way to do this but on a horizontal bar chart?
Anonymous
Not applicable

HI @Anonymous,

 

It will be help if you share some sample data.

BTW, if your percentage value is from measure, I don't think you can direct use other measure to calculate average on it.

 

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors