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 into a Sum/Average/Max/Min/etc. I require to show the data as it is found.

Please! Can someone show how to report data values with out changing the value to a Sum/Average etc, in Service and Desktop??  In my Desktop version, the Modeling tab, the default summariztion option is not active, so I am unable to select any option there.

 

Please tell me how I can show actual data numbers with out summarizing into a Sum/Average/etc modification.

 

CE

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. 

     

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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"

    • ceveland's avatar
      ceveland
      New Member
      9 years ago

      The problem is that I do not ever get that Don't Summarize option when trying to build a report. 

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

        ceveland

         

        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,

    • nirvana_moksh's avatar
      nirvana_moksh
      Icon for Impactful Individual rankImpactful Individual
      7 years ago
      Anonymous- this is not the case with the usage of a Matric visual if I am not wrong? That is something that is needed.
  • 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,