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
meowster
Frequent Visitor

Dynamic Average Line for Column chart based on filter

Hello,

 

I have a simple calculated table and I would like to have column chart by months, together with an average line across.

The calculated table looks like this:

meowster_0-1691924271863.png

 

The column chart looks like this. At the top right hand corner, there is a year_month_order slicer for users to choose how many months of data they would like to see in the chart.

meowster_1-1691925156256.png

I would like to have an average line across, which is dynamic based on the slicer.
So for example,

- if year_month_no 1 to 19 are selected, the average line will show the total of 19 months divided by 19, which is standard across all months.

- if year_month_no 1 to 7 are selected, the average line will show the total of 7 months divided by 7, standard across all months in the chart.

 

The chart would look something like this:

meowster_3-1691925445501.png

 

Thank you.

 

 

1 ACCEPTED SOLUTION
nandukrishnavs
Community Champion
Community Champion

@meowster 

 

Try using the Average line from the Analytics pane.

nandukrishnavs_0-1691941516841.png

 


Regards,
Nandu Krishna

View solution in original post

3 REPLIES 3
nandukrishnavs
Community Champion
Community Champion

@meowster 

 

Try using the Average line from the Analytics pane.

nandukrishnavs_0-1691941516841.png

 


Regards,
Nandu Krishna

Hi @nandukrishnavs ,

 

Thank you! This works after I've changed my chart to clustered column chart. Realised that the "average line" is not applicable on stacked column charts.

Hi @nandukrishnavs , there is no "Average Line" in my Analytics pane, I can only see "Error Bars". What do I need to do to see it?

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.