choice field in sharepoint list

[jps_HHH]

I 've created a sharepoint list that it is connected to PowerBI.

However, one of the column that I created , it is a choice field and its possible to choice more than 1 option. 

The powerBI imported that data as [list] and I extracted throught "transform data" and select "extract values". But is concave the values. 

I would prefer creating a new column in the same row

[v-menakakota]

Hi @jps_HHH ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[jps_HHH]

My multiple choice options are:  Tools; Units; Instruments .

And I would like to count the number of tools , units and instruments.

But the power BI put the lines as:

tools units

tools

tools instuments

intruments

intruments units

Thus, it uses "tool units" as a category for x axis 

[BA_Pete · Accepted solution]

Hi @jps_HHH ,

To create a column that can be used as an x-axis, you need to expand your list to new rows using the button at the top of the list column:

Pete