Count of unable to change to sum

[Anonymous]

Hi, 

I am having a problem changing 'count of' to 'sum' when I try to create a new bar chart. The information is in number format so should be fine or am I missing something? 

[v-juanli-msft]

Hi @Anonymous

I test with your data, but i can'r reproduce your problem.

Does The error which occurs in Editor Queries show once you Get Data->From Excel,

or after you apply some steps in the Editor Queries?

If  the second scenario is, please check each steps by clicking on "setting" icons on the APPLIED STEPS pane.

Best Regards

Maggie

[gmaciel]

Are you sure the column is set as decimal number or whole number?

[Anonymous]

Please see pics for excel format and subsequentt issues in Power BI