Create a pie chart for line items with multiple tags (binary in nature 1,0)

[Anonymous]

I have a dataset which looks like this.

Item No.	Category A	Category B	Value
1111	1	0	$1000
2222	1	1	$2000
333	0	1	$3000
4444	1	1	$2000

I want to create a pie chart which populates the values of both category A and B. 

@ValtteriN 

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Create calculated table.

Table 2 =
SUMMARIZE('Table','Table'[Item No.],
"CategoryA 1",CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[Category A]=1)),
"CategoryA 0",CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[Category A]=0)),
"CategoryB 1",CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[Category B]=1)),
"CategoryB 0",CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[Category B]=0))
)

2. Result:

All set to Max.

Please click here for the pbix file

Best Regards,

Liu Yang

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

[ValtteriN]

Hi @Anonymous ,

Like Amit mentioned you should look into unpivoting the data into a format where you have a category column describing if a row belong to A or B category then use the binary data as the value.

[amitchandak]

@Anonymous , What will the legend.

If you have two measures category A and Category B, then you can have pie on that without legend.

You can unpivot Category A and Category B use the new column as Legend, the 1/0 column as details and value as value