Forum Discussion

Icon for Helper II rank

Helper II

1 year ago

Solved

choice field in sharepoint list

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

BA_Pete
1 year ago
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

3 Replies

jps_HHH
Helper II
1 year ago
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
  Super User
  1 year ago
  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
v-menakakota
Community Support
1 year ago
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.