Footer diagram showing erroneous values

[Syndicate_Admin]

Hello, I am trying to make a standing diagram of the count of the results of a survey, of which a series of questions are answered with "Very Satisfactory" "Satisfactory" "Neutral" "Unsatisfactory" and "Very Unsatisfactory"; the problem is that when trying to do it in one of the tables I display the results with errors in the sum of the answers, however the total of the data does correspond to the total of the sample (attached Excel PivotTable with a standing chart as a reference):

The strange thing is that in another table I did in a similar way I don't get that error:

Could you support me? Thank you very much in advance.

[v-luwang-msft]

Hi @Syndicate_Admin ,

Are you importing your data from excel to powerbi?Is it correct in data?

If the data is imported incorrectly, is it possible to provide specific files for testing.

Best Regards

Lucien