Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Super newbie here,
A simple question:
I have a table with 2 rows:
Sent | 1000 |
Lost | 120 |
I would like to show the data in a pie where the total is "sent" and a slice shows "Lost"
many thanks in advance
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.
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!
yes! the second option, possibly with % of lost (12%)
many thanks
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |