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

Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors