Pie Chart Development in Power BI

[Anonymous]

Hi,

I have the below table with me and expecting a pie chart with legends and values as given below in another table.

I have Unique Sales ID with Order Qty and other fields. 

NET Price should be given as Tool Tip.

1. When the Status is completed, then the Qty should be taken from "Completed Qty" and Net Price from "Net Price" and also keep Completed as one of the legend in chart.
2. When the Status is In Progess and Defect Reason is not available, then take Qty from "In Progress Qty" and Net Price from "InProgress NET" and keep In Progress as one of the legend in chart.
3. When the Status is In Progress and Defect Reason in available, then take the Qty from "Defect Qty" and Net Price from "Defect NET Price" and keep all defect reasons as legends in chart. 

I do not want many measures to be made as per the status or defect reasons, since the defect reasons may increase frequently.

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Similar to the previous formula.

Refer to the sample.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , You can create qty column like

new column

Qty =
Switch( True(),
[Status] = "completed" , [Completed Qty],
[Status] = "In Progess" && isblank([Defect Reason]) , [In Progress Qty],
[Defect Qty]
)

Same way you can add Price  column

[Anonymous]

You have given the formula to get Qty, how are we going to handle the legends which is two columns ?

@amitchandak