Forum Discussion

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 ...

Community 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

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:

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