How to add data together in Pie Chart

[Niels_T]

Hello,

I was making a pie chart for age and device category, however, when I made the pie chart it didn't gave me the visuals I wanted to see.

This is the result I got:

I would love to merge all that data together, so that I only have 3 device categories, but inside a sum of all the age groups inside. 

Best regards,

- N

[PhilipTreacy]

Hi @Niels_T 

Download PBX file with these visuals.

I'm not sure if you are after this

or this

Please check the PBIX file linked to above.

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[Niels_T · Accepted solution]

I have found the solution!

I basically had to add a simple slicer on with age so that I can filter through the different ages. 

Sorry if my explanation wasn't clear enough. I'm still new.

Thank you for all the help though! 

Best regards,

- N

[negi007]

@Niels_T  Are you looking for below output. let us know if you want something else

[amitchandak]

@Niels_T , This seem fine. what is expected output. Also you can try tree map

[Niels_T]

In my pie chart you see multiple mobile, tablet, desktop categories for each age-group.

I would like to have the data of all age groups into one device category and display it in a pie-chart.

The tree chart is a good alternative, however, I am curious how you could also do it in a pie-chart

[PhilipTreacy]

Hi @Niels_T 

A Treemap may be better suited to what you are trying to do - see this example PBIX file.

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.