Forum Discussion
Power BI visualization issue
I am trying to do a bar chart showing the sum of defects for every week of the year. I already did the calculation in excel and successfully transferred the data table to power BI. Every week is showing only 1 defect. See pictures.
10 Replies
You are using COUNT to summarize your data so effectively for each week you are saying you have one record.
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
