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

[Anonymous]

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 to be as In Progress % and mentioned in yellow color.

However when calculating the In Progress %, I also need to consider the defect reason for pending orders and separate into Machine Break % and Lubricant Over % which will be in different colors.

So totally my pie chart will have 4 sections -- Completed, In Progress, Machine Break and Lubricant

Please help. 

[Fowmy · Accepted solution]

@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]

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])