Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
df123445
Helper I
Helper I

showing subtotal as pie chart slice

Super newbie here, 

 

A simple question: 

I have a table with 2 rows:

Sent1000
Lost120

 

I would like to show the data in a pie where the total is "sent" and a slice shows "Lost" 

 

many thanks in advance

6 REPLIES 6
Adamboer
Responsive Resident
Responsive Resident

Sure, here's how you can show the data in a pie chart:

First, you need to calculate the percentage of lost items compared to the total number of sent items. To do this, divide the number of lost items (120) by the total number of sent items (1000) and multiply the result by 100.

120 / 1000 = 0.12 0.12 x 100 = 12%

So, the slice representing "Lost" should be 12% of the pie chart, and the rest of the pie chart should represent "Sent."

You can use any graphing or visualization tool to create the pie chart. Most tools have a pie chart option where you can input the data and adjust the slice sizes accordingly. Make sure to label the chart appropriately so that the viewer knows what each slice represents.

Thanks a lot, but I don't know how to implement that in Power BI, I'm not sure how to go from my simple 2 rows table (as in my original post) to the final rapresentation. 

df123445
Helper I
Helper I

I would like to create a chart that shows a total of 1000 (the sent records) and a subtotal for the "lost" records.

Basically a graph that shows:

"out of 1000 sent we had 120 lost packages" 

Basically the lost packages are a subgroup of the total sent.

 

I hope it makes sense! 

@df123445 ,

Are you expecting something like this?

Arul_0-1680084722634.png

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


yes! the second option, possibly with % of lost (12%) 

many thanks 

Arul
Super User
Super User

@df123445 ,

Please provide the expected format atleast in a rough way.

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.