Adding an Average Line to Horizontal Bar Ch

[Anonymous]

I am trying to get an average line to be displayed in my horizontal bar chart for each. When I go in and add an average line, similar to below, it averages the entire dataset.

I am hoping to insert in an average line for each individual channel, and have the averages for each channel displayed on the

bar...Is this something we can do?  

[v-zhenbw-msft · Accepted solution]

Hi @Anonymous ,

Sorry for that Power BI cannot add an average line for each channel in bar chart, it just can add an average the entire dataset line.

We provide a solution and you can refer it.

1. Create an average measure.

Measure = AVERAGE('Table'[values])

2. Using line and clustered column chart. Then we can change the line stepped in shape.

3. Or we can use BulletChart from Power BI visual appsource.

If you have any question, please kindly ask here and we will try to resolve it.

BTW, pbix as attached.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.