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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors