pie charts

[SelflearningBi]

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

[Anonymous · Accepted solution]

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.

[amitchandak]

@SelflearningBi , My advice would be to unpivot all 4 columns and then try

https://radacad.com/pivot-and-unpivot-with-power-bi