Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

  • Arul's avatar
    Arul
    Icon for Super User rankSuper User

    Anonymous ,

    Please provide the expected format atleast in a rough way.

    Thanks,

    Arul

  • Anonymous's avatar
    Anonymous
    Not applicable

    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! 

    • Arul's avatar
      Arul
      Icon for Super User rankSuper User

      Anonymous ,

      Are you expecting something like this?

      Thanks,

      Arul

      • Anonymous's avatar
        Anonymous
        Not applicable

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

        many thanks 

  • Adamboer's avatar
    Adamboer
    Icon for Responsive Resident rankResponsive 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.

    • Anonymous's avatar
      Anonymous
      Not applicable

      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.