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!

    • 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

  • natabird3's avatar
    natabird3
    Skilled Sharer
    7 years ago

    Make sure to change the column to decimal format then you will be able to change to don't sum.