Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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
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.
@AshDil , when you show sum(Table[Value]), by segment it should do that ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |