Count of Multiple selection data in one row

[Anonymous]

Hi all,

I have a question about visualizing the multiple choices here.

For example, if i have a data like this in the SharePoint List:

When i visualize it using the intergate Power BI, i will get this:

The question is:

1. I would like to count by 'Product Name', for example, there is a total of 2 times 'Choice 1' has been choosen over total of 5 customer, but Power BI seems to group the data according to the row, example: Choice1, Choice 2 as 1 data.

2. For the right bar, i would like to have them visualize as:

Customer	Count of Product Name
A	2
B	2
C	1
D	1
E	2

Total count of Product Name: 8

Thanks a lot for the help.

[v-janeyg-msft · Accepted solution]

Hi, @Anonymous 

Accoding to your description, you should use this method to connect to sharepoint list data. I create a sample in my sharepoint list to operate.

And then you can expand the product name in Power Query.

Like this:

Then you will get all rows.

Finally you can count the name in desktop.

Like this:

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey

[lbendlin]

This should be standard functionality.  Here is an example from a similar sharepoint list.  Assuming you have expanded your Product Name list column ("Group"  in my example) into new rows, you then get: