Want to negative values to be subtracted in respective segment

[AshDil]

Hi,

I have data as follows:

SegValueCat

Furniture	100	chairs
Gadget	200	mobile
Furniture	300	table
Gadget	-150	tv
Furniture	-200	fan
Gadget	400	Laptop
Furniture	-300	Book Case
Gadget	-200	Tab
Furniture	300	Sofa
Gadget	200	Router

I need to show above data in pie chart only. So I have added seg column to Legend, Cat to details and Value to Values. I'm getting pie chart as follows:

I want negative values to be subtracted from respective segments. When I sum up the Gadget segment the total must be equal to 450(i.e, 400+200+200-200-150) and Furniture Segment must be 200 (i.e, -300+100-200+300+300)

Please help me to do.

Thanks,

AshDil

[v-eqin-msft]

Hi @AshDil ,

Could you tell me if my post helps you a little? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Best Regards,
Eyelyn Qin

[v-eqin-msft · Accepted solution]

Hi @AshDil ,

To my knowledge, negative values are not supported in Pie or Donut charts. 

If you want this in power bi, let the power bi community to know this things and give your votes at power bi site's feedback - Ideas

I'd suggest you use drill through to get Cat in details as shown below:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@AshDil , when you show sum(Table[Value]), by segment it should do that ?

[AshDil]

Hi @amitchandak,

Yes I want values at Segment level but I need to show Cat in details.

Thanks,

AshDil