multiple choice selection to a column chart

[Teacher-Hartman]

I have a column in my SharePoint, where students can select more than one item. I would like to create a column chart to display for them how many times they have selected each of the choices. I had it working when it was just the single selection, but when changing it to multiselect, the chart is not displaying. This is what I had before I made the change to multiselect. 

I'd appreciate any help you can offer. Thank you!

[v-xiaochen-msft · Accepted solution]

Hi @Teacher-Hartman ,

I made a sample for you.

AddColumns(GroupBy(Ungroup(LIST291,"myChoice"),"Value","temp"),"count",CountRows(temp))

Best Regards,

Wearsky

[Teacher-Hartman]

It worked perfectly! thank you!