Incorrect legend values with bar chart

Hello everyone

I´m having issues with a stacked bar chart, the query of my data looks something like this:

The table has no relationships other than  a date table, I checked without it and I had the same issue.

So that way the chart shows for each month the amount of money spent on each zone, the problem is that is only showing values of C (as you can see in the graph). I checked and the amount shown in the bars and they are correct for C.

Any help would be greatly appreciated.

Thanks in advance

Edit: Needless to say but I have no filters