Forum Discussion

michaeljc70's avatar
michaeljc70
Advocate II
10 years ago

Make a column not sum/count

I've used Power BI quite a bit lately with a SSAS cube and some Sql Server queries and created many visualiations.  I am still fairly new to this though and cannot figure this out.    I imported a ...
Need Help
uday64657's avatar
uday64657
New Member
10 years ago

Any solution for this Problem.

I am also facing same issue. In Power BI desktop, I can able to see column with Sum that allowing to show actual count in Graph. However when I publish same to Power BI Online, it broken and showing count of the column.

v-esdev's avatar
v-esdev
Microsoft Employee
9 years ago

Hi All,

 

I am also facing same issue. does anyone find solution for this.

 

Please help me on this.

 

Thanks,

Eswar

  • AWeichselbaum's avatar
    AWeichselbaum
    Advocate I
    9 years ago

    I just figured this out.

     

    Under Fields, click on the field which is being auto-summarized. Once selected, go to the top ribbon and click "modeling". You will then see a button called "Default Summarization..." click this, and select 'do not summarize'. Above that button you can also change what the data is - this is useful for telling Power BI that the data is a postal zip code, for instance.

    • RBilton's avatar
      RBilton
      New Member
      9 years ago

      Perfect!  That was the answer.   Thanks so much for posting. Your answer keeps on giving!

    • smemusi's avatar
      smemusi
      New Member
      6 years ago

      I can't see that option. Please help

      • natabird3's avatar
        natabird3
        Skilled Sharer
        6 years ago

        smemusi 

        You should try selecting the value that you need in the fields column, after which in the top menu select the summarization that you desire (dont summ for isntance). and it should solve your problem, hoep this helps.

  • Rolandek's avatar
    Rolandek
    New Member
    9 years ago

    Change the type of the field in the query to Decimal or whole number from ANY. it worked for me

  • nickperez's avatar
    nickperez
    New Member
    7 years ago

    Click on the element you don't want to summarize, then go to the modeling tab, around the middle are the properties, select default summarization, don't summarize. Worked on Version: 2.65.5313.701

  • Rolandek's avatar
    Rolandek
    New Member
    9 years ago

    Change the type of the field in the query to Decimal or whole number from ANY. it worked for me

  • kmpiscopo's avatar
    kmpiscopo
    New Member
    9 years ago

     

    Check the data format within your Excel document.  I've found that if the values in my tables in Excel are not "Number" (e.g. if they are listed as "Accounting" or "General" or "Custom"), then Power BI doesn't recognize the data as values, and your only options for pie or bar charts is either "Count of (data field)" or "Sum of (data field)", etc.

    Hope this helps!