Forum Discussion
Need to have Do Not Summarize on Values
I attended a Power BI workshop seminar here in town last week, and was able to discover the solution of setting the default summarization to Don't summarize.
So, that seems to be resolve my problem.
Thanks for your time and help.
ceveland You have this option for any numeric field in the visual itself when you are creating the reports. The default behavior is going to summarize, so you need to specify this each time (from my understanding). When you add the field to the values section you click on the down arrow to the right of the field name and select "Don't Summarize"
The problem is that I do not ever get that Don't Summarize option when trying to build a report.
v-sihou-msftMicrosoft Employee
I think you are using "Connect Live" mode. Then you should check the data type in your source. Make sure it's not numeric type so that it will not be aggregated.
Regards,
I attended a Power BI workshop seminar here in town last week, and was able to discover the solution of setting the default summarization to Don't summarize.
So, that seems to be resolve my problem.
Thanks for your time and help.
ericspletzerHelper I
This does not resolve the problem in my case. I am pulling project data from MS Project. I pull the "percent work completed" field. It's default is a decimal number. Whether I have the default of "Do not Summarize" checked, or whether I change this field to a percentage or a whole number, it does not give me the option to "do not summarize"
See below for a videohttps://www.dropbox.com/s/mx67w108o7573ur/2019-01-28%2015-24-36.flv?dl=0