Forum Discussion
Pie Chart Development in Power BI
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.
- 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.
- 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.
- 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.
Hi Anonymous ,
Similar to the previous formula.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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
You have given the formula to get Qty, how are we going to handle the legends which is two columns ?
Hi Anonymous ,
Similar to the previous formula.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
