cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Average in Drill-down column chart

Hi Guys,

 

  I am using Drill-down column chart by ZoomCharts and I found that the average calculation is on the average of each slice and then average of all slices at that level which in terms not giving exact precision of values. 

 

  If you see in my case the hovered bar which is Agile Cockpit Development shows 3.48 but if I drill down to it the actual average I get is 3.54 which display on right top.

 

I tried to get the calculation how it is being done.

e.g. ChildLevel 1 = (1+2+3)/3 = 2

       ChildLevel 2 = (2+2)/2 = 1

       ParentLevel = (ChildLevel1 + ChildLevel2)/2 = (2+1)/2 = 1.5

 

  What I expect at ParentLevel avergae is (1+2+3+2+2)/5 = 2

 

Any solution to get this.

 

Energy1.PNG

 

Energy2.PNG

 

Thanks,

Sud

2 REPLIES 2
Microsoft
Microsoft

Hi @Anonymous,

 

In my test, the average value is correct after I drill down to next level.

1.PNG2.PNG

 

In your scenario, how did you calculate the [Energy Level]? Please provide sample data to illustarte your problem.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi @v-yulgu-msft,

 

  My source is in a different format having the hierarchical data.

 

  I am attaching snapshots of source and the average calculation.Source.PNG

 EnergyDetails.PNG

I hope this will help you to understand.

 

Thanks,

Sud

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors