Forum Discussion
admin_xlsior
Post Prodigy
Post ProdigyNegative 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 ...
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:
v-chenwuz-msft
Community Support
Community SupportHi 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: