Forum Discussion
Make a column not sum/count
You need to go back to the table/query click on the dots to the right and select edit query
When the data list is displayed, find the column that you want to sum. right click on the column title to select the column and display the menu, then select "change type" and select the appropriate type such as "decimal number"
Click the "Close and Apply" button to update the query.
Now when you click on the field in the "Values" section you should have all the options
Hello,
I am new to Power BI, so need expert help with the same issue. Earlier I was seeing only Count option, but after following your suggestion, I could see all other options except "Don't Summarize" like Sum, Average, Median etc.
I tried different data types like Decimal, Whole Number, Text and Duration but with no luck.
Could you please help me in finding the "Don't Summarize" option.
Thanks in advance
I am also new to Power BI and am having the same issue with a scatterchart. I have cost on one axis and usage on the other, and it insists on somehow summing my data. How can I get to show me the proper range of data?
I am also struggling with aggregation. I do not want to summarize my data, and I want to see all data points. Even after I have clicked on "Do not Summarize" in modeling tab, my data is still getting summarized. only options are count or distinct count.
Even year is getting counted??
This is weird, if I use one graph, dates work fine, but with other it doesn't. Never had this issue in tableau..
Please help
date works in bar chart but not in scatter
- This is the answer that fixed the problem for me. There should be a way to mark this as the correct or most accepted answer the way that StackOverflow has it. Thanks!
This helped on some columns that were marked number and when I switched t it to text, it removed the sum. Thanks. However not working on all of my columns.
