Chart Pie chart negative values

[Syndicate_Admin]

Good, I'm trying to show the data from a table in a pie chart and in the table I have some results where the number is negative, and in the graph I'm just taking the positive values, the negative results don't show them.

I would like to show both positive and negative values on the chart.

Greetings, thank you.

[v-henryk-mstf]

Hi @Syndicate_Admin ,

Agree with the comments given by @AntonioM . What is your specific business scenario and can you provide more detailed information, maybe I can give you the best reference.

Looking forward to your reply.

Best Regards,
Henry

[AntonioM · Accepted solution]

If you have some negative values a pie chart might not be the best option.

You could use ABS() to get the absolute value, which a pie chart would plot, but then you'd need a way to show which are negative or not (SIGN() could help with that). Or, you could have two pie charts, one for the positive and one for the negatives?