Power BI is ignoring negative values in a column Amount and summing all as positive

[kalkhudary]

Helllo Community, 

I am working on generating a bar chart that sums the amount spend per quarter and Fiscal year. I want to sum the amount of spend but Power Bi is summing the all values considering them positive. 

I have checked my query and looks that it is presenting the positive and negative values and in the table format the column looks correct;however when summing the column, it is just considering them as positive. Any idea what I am missing, is there anything I need to consider to ensure that Power BI reads the negatives.

[Poorva_Awale]

Hi All,

Even I am facing similar issue , my data contains both negative and positive values in column 'Revenue', however when i use the same column in my Table visual the negative values are neglected and the table shows only the positive values. I checked that this might be due to the summarization i am doing on the column to get the grand total. How do we handle this, do we have to do any kind of special formatting, etc? 

[kalkhudary]

@Poorva_Awale Try to change the data type of the column in the query to Decimal. It should resolve the issue.

[aj1973 · Accepted solution]

@kalkhudary 

Your screenshots don't explain much but it sounds like there Format issue somewhere !

Can you show this part in Power Query please?

Can you share a sample?

[kalkhudary]

@aj1973 There was a issue in the data formatting. I have resolved it and it is working now. Thanks for your input.