Forum Discussion
Pie Chart with percent data on multiple columns
Super UserAnonymous , use unpivot or transpose and then you can count
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
If I use those, it breaks the rest of the table and formulas that I have. Are there any other ways?
v-yingjlCommunity Support
Hi Anonymous ,
If you do not want to break the initial table, you can use union() function to create a new calculate table:
new table = UNION ( SUMMARIZE ( 'Table', 'Table'[Type1] ), SUMMARIZE ( 'Table', 'Table'[Type2] ), SUMMARIZE ( 'Table', 'Table'[Type3] ) )Rename the column as 'Type', create a pie chart to get the result:
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-yingjl,
Thank you! That did work partly, but I still have a couple of issues where I would love to get your insights:- By creating a separate table, I lost the ability to filter my data dynamically. Is there a way I can add another column onto this table "ID" and then create a relationship between both tables so I don't lose the filtering functionality?
- Although it grouped the items of some of the tables, I only got 28 in the pie chart when the real count is 46. Any ideas on what could be trigering this?
Thanks
- v-yingjl
Hi Anonymous ,
Could you please consider sharing a sample .pbix file for further discussion? Remember delete or replace sensitive information when you share it.
Best Regards,
Yingjie Li