Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
Show and Tell
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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

 

amitchandak