Negative value

[admin_xlsior]

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.

[v-chenwuz-msft · Accepted solution]

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:

[amitchandak]

@admin_xlsior , Visual with y Axis can be used like, Line, Area, Scatter etc