Multiple column values into Pie Chart

[Anonymous]

Hello Community,

I need to count unique values in a column that contains multiple values and represent each of the unique values on a pie chart. The data in the column isn't very clean as it's coming directly from Forms into a SharePoint list.

Column

Current Pie Chart

How might I go about counting each of these and then representing the unique values on a pie chart?

Thanks

[nandukrishnavs · Accepted solution]

@Anonymous 

Clean your data using Edit Query.

You have to split your column into rows. You could refer to this link - https://community.powerbi.com/t5/Desktop/How-to-split-the-the-Column-into-Multiple-rows/td-p/253361

Then you can plot the pie chart.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[Anonymous]

That worked, thanks