Forum Discussion
Power BI visualization issue
Best practice is to always create a measure and use it in the Visual: Total Defects = SUM(Table[Defects])
If you directly use the column, then you have to be careful about the default summarization, which in your case seems to be count rather than sum.
How do I chart the values for defects without any count or sum?
I'm a bit confused by your question. Are you saying you're happy with the answers given (i.e. use 'sum' to aggregate your defects on a chart either by visually changing the aggregation used, or by changing the default summarization for defects or by creating a measure to sum the defects and using that on a visualisation) but it's still not working for you or are you asking how to chart values without using any aggregation( no sum, no count, no average or anything like that)?
If it's the latter, then you set the 'default summarization' for your defects field to 'don't summarize' and drag the field on to a visualisation. Be aware that Powerbi is all about aggregations and it might just default to count at this point anyway because otherwise it doesn't know what to display.
If i'm still not understanding your question, attach a picture of what you want and/or upload your pbix file and i'll take a look at it
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?
