Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

No 'don't summarize' option on barchart value

Hello. I read few topics and still couldn't filnd a solution.


I have a table with board games and one of a column is "average rating" which is a decimal between 1 and 10.




On modeling page default summarization is off




When i put board game names with avg raiting to see top raiting games on clustered bar chart i have no option to set "dont summarize". It shows me some weird data - there is no option that one game have value 56 if raiting is a value between 1 and 10. One game name exists only once in a table. I dont have this option on any bar chart with this column (Avg rating)





How to fix it ?

Community Support
Community Support

Hi @nakerax 


There is no Dont summarize option in clustered bar chart. Since you said “One game name exists only once in a table.”, it should work because the sum value is same as the original value when there is only one rating value for every game name. Can you convert the chart to a table visual and check whether the values are correct? And are the data from the same table?


Otherwise, can you provide some sample data or upload the pbix file without any confidential or sensitive information  and share the link here? 


I cannot reproduce what you get in the visual. I tested with some dummy data and the clustered bar chart displayed well with the sum of value as the image shows below.



Best Regards,

Community Support Team _ Jing Zhang

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

Super User IV
Super User IV


For charts, there has to be a summarization option as it works on an axis.

If you want to achieve the same, change the chart to a table visual, and apply conditional formatting on the Average Rating, 


If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up

Blog - Data Visualization

Website   YouTube    LinkedIn   PBI User Group

Helpful resources

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors