Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Pie Chart to show the Completed % and In Progress % and Defect %

Please find my below manufacturing data. I need to create a pie chart which gets total order quanity and completed quanity and gives the completed % in green color, then the remaining pending orders ...
Need Help
Show and Tell
  • Fowmy's avatar
    Fowmy
    6 years ago

    Anonymous 

    Add a few columns then you can have it:

    You can download the file: HERE

     

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
6 years ago
This may not be the most efficient solution but you could create 4 separate measures and add them to the values of a pie chart:

Completed = SUM(table[Completed Quantity])
Pending = SUMX(FILTER(table, ISBLANK(table[defect reason])), table[Order Quantity] - table[Completed Quantity])
Machine Break= SUMX(FILTER(table, table[defect reason] = "Machine Break"), table[Order Quantity] - table[Completed Quantity])
Lubricant Order= SUMX(FILTER(table, table[defect reason] = "Lubricant Order"), table[Order Quantity] - table[Completed Quantity])