Forum Discussion
Negative value
Hi,
This is some kind of weird question. As we know negative value is "impossible" in Pie or Donut chart, what are the other options except the good 'ol bar / column chart ? I mean a visual that look different then that, but it is good and nice to see for negative value.
Or is there any "pie chart like" that somehow able to show negative ? Just pushing my luck 🙂
Thanks.
Hi admin_xlsior ,
So the final visual you want is a pie chart and with the result of negative number. Did you try to adjust the values of the pie chart in order to display the negative number. I mean replace it by measure.
Maybe the expression you can refer as below.
Measure = ABS ( SUM ( 'Table'[values] ) )My orgianl data:
Comparison of values directly and measure result:
2 Replies
admin_xlsior , Visual with y Axis can be used like, Line, Area, Scatter etc
Hi admin_xlsior ,
So the final visual you want is a pie chart and with the result of negative number. Did you try to adjust the values of the pie chart in order to display the negative number. I mean replace it by measure.
Maybe the expression you can refer as below.
Measure = ABS ( SUM ( 'Table'[values] ) )My orgianl data:
Comparison of values directly and measure result:
