Forum Discussion

Narendra's avatar
Narendra
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago
Solved

Column Names contains prefix as Sum Of

Hi All,

 

I have taken table as a  visualization in my Power Bi Desktop file. In this table I required total for all value fields , for this I have selected all value columns type as Sum but in this few column name heading getting prefix as Sum Of column names .But I required the all value filed names without Sum of prefix . How we will achieve this total without prefix as sum of column names in headings

 

Regards,

Narendra M

 

Need Help
  • djnww's avatar
    djnww
    10 years ago

    Hi Narenda,

     

    The 'Sum of' will occur when you apply an aggregation which is different to the field/column's 'Default Summarization'.

     

    What you need to do is go to the Modelling tab, select the column in question, then change the 'Default Summarisation' to 'Sum'. Now go back to the report design and re-create the table from scratch. The 'Sum of' will no longer appear.

     

    Regards,

    Dan

14 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Not sure I understand, but you should just be able to right click the headings and rename them.

  • Narendra's avatar
    Narendra
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    Hi,

    My column names doesn't have any prefix as  Sum of but when i add this columns in a table grid  then it is showing a Sum of Column Name.

     

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      10 years ago

      Hmm, any chance you can upload a screen shot, I am not seeing that behavior in the default Table visualation with either Measures or Columns so apparently I am not simulating this correctly in my environment.