Forum Discussion
Don't Summarize....still summarizes...?
Hi Anonymous ,
Thanks for reaching out to the Microsoft fabric community forum
The issue was that the Crime values weren't showing in the visual because they weren't aggregated properly.
In Power BI, when using bar or line charts, we must summarize numeric columns like Crime using Sum, Average, or similar aggregations.“Don’t summarize” works only in visuals like tables or cards. To fix it, I dragged State to the X-axis and Crime to the Y-axis, then selected Sum as the aggregation. Now the line chart renders correctly by showing the sum of crime incidents per state.
Please find the attached pbix file for youe reference.
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it
Best Regards,
Tejaswi.
Community Support Team.
Hi Anonymous ,
Thanks for reaching out to the Microsoft fabric community forum
The issue was that the Crime values weren't showing in the visual because they weren't aggregated properly.
In Power BI, when using bar or line charts, we must summarize numeric columns like Crime using Sum, Average, or similar aggregations.
“Don’t summarize” works only in visuals like tables or cards. To fix it, I dragged State to the X-axis and Crime to the Y-axis, then selected Sum as the aggregation. Now the line chart renders correctly by showing the sum of crime incidents per state.
Please find the attached pbix file for youe reference.
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it
Best Regards,
Tejaswi.
Community Support Team.
Hi Anonymous ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
Tejaswi.
Hi Anonymous ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution so that other community members can find it easily.Thank you.
Tejaswi.Hi Anonymous ,
I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.
If the response answered your query, kindly “Accept as Solution” and Give “Kudos” to help others in the community benefit from it as well.
Thank you.
Tejasswi.