Forum Discussion

EmiliaB_123's avatar
EmiliaB_123
Icon for Helper II rankHelper II
5 years ago
Solved

Export to Excel changes column names

Hello everyone, when I export my table from Power BI App to Excel part of the column headers get changed from "quantity" into "sum of quantity". I changed the headers in Power BI in order to have a ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi EmiliaB_123 ,

     

    Oh! Sorry for my misunderstanding!

    Please allow me to describe your issus again:

    When you export the visual data from apps to excel , the prefix of "Sum of " appears in the column name , and you have set the default summarization to "Sum", right?

     

    Now I could reproduce it! Please take a look at the differences:

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi EmiliaB_123 ,

 

Please go to the Data view, select the column tools 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.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • EmiliaB_123's avatar
    EmiliaB_123
    Icon for Helper II rankHelper II
    5 years ago

    Hi Eyelyn9,

    thanks for your feedback but this field is already set as "sum".