Forum Discussion

ceveland's avatar
ceveland
New Member
9 years ago
Solved

Need to have Do Not Summarize on Values

Hello, I know there have been previous posts on this topic, but I am yet to find a solution to this problem. Most of the data that I need to use in Power BI reports, I can not aggregate or summarize...
Need Help
  • ceveland's avatar
    ceveland
    9 years ago

    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. 

     

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

ceveland

 

As you mentioned, you default summarization is greyed out. Right?

 

What's your data source? Did you use import mode or direct query? Please verify the data type of the data field, it must be numeric. If it's already numeric fields, the default aggregaion type supposes to be set in data source, like SSAS with live connection. Otherwise you have to set the summarization on visual level like Anonymous suggested.

 

Also see a similar thread bleow:

https://community.powerbi.com/t5/Desktop/Default-Summarization/td-p/20726

 

Regards,