Add New column

[Anonymous]

Hi Expert,

if we add a new column in excel or any database and then  we just refersh the table and and can see that new column is appeared in power BI but the column contains numerical value does not show as sum sign Σ unless we edit the query and add that coulmn name and datatype

is there any alternate way we can do it without adding column info in edit query

Shree

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

The symbol appears when the default summarization is set to some aggregation like Sum, Average, Count etc in the Modeling tab of Power BI Desktop like below. If you reset the default summarization to "Do Not Summarize", the symbol will disappear.

[amitchandak]

If you are creating it as a column. You will get it. If you create it as a measure than it appears in visualization. 

How are you creating, can you share steps?

[Anonymous]

for an example 

if i add product column in excel  then i refersh power bi table and the new column is populated automatically

but when i am adding sales column in excel then it populating but not with sum sign before the column and appear only when i add it edit queries