Forum Discussion

jps_HHH's avatar
jps_HHH
Icon for Helper II rankHelper 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 impo...
Need Help
  • BA_Pete's avatar
    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

jps_HHH's avatar
jps_HHH
Icon for Helper II rankHelper 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's avatar
    BA_Pete
    Icon for Super User rankSuper 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