Forum Discussion
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 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.
2 Replies
- AllisonKennedy
Community Champion
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])
