Forum Discussion
Create a pie chart for line items with multiple tags (binary in nature 1,0)
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.
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
3 Replies
- amitchandak
Super User
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
- ValtteriN
Community Champion
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. 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
