Pie Chart with percent data on multiple columns

Question

Hi there,I have an excel file that has the following fields:Type 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; Type 2&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp;Type 3Sun&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Sun&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MoonMoon&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Planet&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SunI need to have a Pie Chart that displays the total split % or volume such as :Sun - 3Moon - 2Planet - 1&nbsp;The problem is that I cannot put all of their legends, so I will get a combine value but rolling up only to the Types existent in Type 1 ( or Sun | Moon).&nbsp;How can I create a pie chart that shows all of the data labels with their combined values?&nbsp;Thanks

amitchandak · Answer

Anonymous , use unpivot or transpose and then you can count
https://radacad.com/pivot-and-unpivot-with-power-biTranspose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

anonymous · Answer

If I use those, it breaks the rest of the table and formulas that I have. Are there any other ways?

v-yingjl · Answer

Hi&nbsp;Anonymous&nbsp;,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:&nbsp;Best Regards,Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Hi&nbsp;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 · Answer

Hi&nbsp;Anonymous&nbsp;,Could you please consider sharing a sample .pbix file for further discussion? Remember delete or replace sensitive information when you share it.&nbsp;Best Regards,Yingjie Li

Forum Discussion

Pie Chart with percent data on multiple columns

5 Replies

Related content

Percent of Column Total

Percent of column Total

Sequential Order column based on multiple criteria

Percent between 2 columns

Calculate percent based on multiple columns