Forum Discussion

SelflearningBi's avatar
SelflearningBi
Helper III
3 years ago
Solved

pie charts

Model Name Qty Value OD1 Yes/No OD2 Yes/No OD3 Yes/No OD 4Yes/No A 2 100 Yes   No Yes B 3 200 Yes Yes     C 1 300 No No No No I would like to create 3 pie ch...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  SelflearningBi, 

     

    Here's my solution.

    1.Create a new table for a slicer.

     

    2.Create a measure to return different restuls.

    Measure = SWITCH(SELECTEDVALUE('Table (2)'[Type]),"number of model name",COUNT('Table'[Model Name]),"quantity",SUM('Table'[Qty]),"value",SUM('Table'[Value]))

    3.Create the pie chart and the slicer. The results are as follows.

     
     

    Best Regards,

    Stephen Tao

     

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