Create pie chart counting occurrences of a number in a column

[Anonymous]

Hello,

This is probably the easiest thing every but I am new to powerbi and don't know what I am doing.

I have a numeric column called [NumberofAmendments] which contains either 1, 2, or 3. I would simply like to create a pie chart looking at the breakdown of these numbers (i.e. how often they occur).

Any help is appreciated.

Thanks

[speedramps · Accepted solution]

Hi MitchellG

Click the pie visual

drag the NumberofAmendments column to the Legend box

drag the NumberofAmendments column to the Values box

click on the arrow in the Values box and select Count

Well done on crrateing your first Pie Chart!

Please click the thumbs up and the accept As Solution button.

Only one problem per ticket please, Dont keep adding more problems here. Thanks  😀