I got a dynamic Pie Chart, which is created depending on the chosen values.
Sometimes the result is, that there are postive and negative values in this chart. Since, I try to figure out a certain potential of the variable, this case is happening a lot. It means that the variable reached its full potential which I would like to show in this pie chart in some way.
Is there any chance to do this nicely?
Thanks a lot in advance.
PIE Chart can't show Negative Values...
There are some tricks to show -Ve values but it will misguide to the analyst.
check below thread.
Logically it doesn't make sense to have a fabs slice on a pie chart unless all your values were negative, all you are doing is under proportioning the counterweight.
As others have stated, a pie chart isn't really the best option because it cannot show negatives and positives together on one pie.
You could, however, create two expressions and group them so the user can switch between positive results and negative results using the cyclic button.
EXPR1 - Positives: RangeMax(Value,0)
EXPR2 - Negatives: RangeMin(Value,0)
This works best when there is a legend with numbers showing and the Suppress Zero Values option unchecked.