Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Pie Chart with percent data on multiple columns

Hi there, I have an excel file that has the following fields: Type 1         |        Type 2      |     Type 3 Sun                    Sun                   Moon Moon                Planet      ...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

    • v-yingjl's avatar
      v-yingjl
      Icon for Community Support rankCommunity Support
      6 years ago

      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 Li

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        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:

        1. 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?
        2. 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