Forum Discussion
Helper IIIpie 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 chart showing total pertange of all together OD1~ OD4 is yes/ no/blank in value, quantity, and number of model name.
I would like to know is it poosible to do with 4 ODs in one pie char? if yes how to do it? thanks
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.
2 Replies
- amitchandak
Super User
SelflearningBi , My advice would be to unpivot all 4 columns and then try
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.
