Forum Discussion
Power BI visualization issue
I need Week # on the X axis. I want a bar chart showing the number of defects for each week, so no aggregation. Where might I change the default summarization?
Ok, it looks like your original question still stands and you haven't followed the previous answers given by myself or the other dude. So you are probably at the start of your powerbi journey.
For long term answers : read this https://docs.microsoft.com/en-us/power-bi/service-aggregates i know it says powerbi service but it applies to desktop too
Short term : You think that you don't want to aggregate your number of defects but actually you do. And you want to use SUM. Go back to your visualisation , you have week# on the axis and Defects in values. Go to the Values section, click on the small triangle next to Defects. We think that a tick will show next to Count but you really want to tick Sum. So tick Sum and your visualisation should show what you want. If it doesn't, there may be an issue with the data type used for defects so attach your pbix and i'll look at it.