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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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