Forum Discussion

martenm's avatar
martenm
New Member
9 years ago
Solved

data from custom SPO list (newbie question)

Hi, I am a Power BI noob, and this is probably a rather basic question, so forgive me:   I have a custom SPO list with different columns (Person, Alternatives, Checkbox, Text and so on).   I woul...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi martenm,


    For numeric field, Power BI Desktop will perform aggregation. For more details, please review this article. Based on your second screenshot, the field is text data type, when you drag it to table visual, Power BI desktop will show unique value of this field if you have no other field to identify it.

    Based on your third screenshot, you only drag a text  field to pie chart. To make the pie chart display propely, you would need to drag numeric field to Values of pie chart, this is the way that pie chart works. There is an example as follows, and you can review this video to get more details.


    Thanks,
    Lydia Zhang

martenm's avatar
martenm
New Member
9 years ago

Thanks for the answer!

The thing is, I do not get an error message, it just sort of wont work. I suppose I ha misunderstood something fundamental in how Power BI works?

 

I will look at the link you sent, thank you!

Get data - More - Online services - SPO list, Connect
Insert url to Sharepoint site
Select list with checkbox, ok

Then I get all the list columns in the right hand, so that's ok.



But if I make a selection, it does not do what I expected. The example is an alternatives column, with 4 options. Bower BI lists the options, but that's all. I expected it to deliver sums or something ...?


And if I click a diagram for visualisation, it goes blank.

 

This is the content of the column from thje SPO list, in SPO.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi martenm,


    For numeric field, Power BI Desktop will perform aggregation. For more details, please review this article. Based on your second screenshot, the field is text data type, when you drag it to table visual, Power BI desktop will show unique value of this field if you have no other field to identify it.

    Based on your third screenshot, you only drag a text  field to pie chart. To make the pie chart display propely, you would need to drag numeric field to Values of pie chart, this is the way that pie chart works. There is an example as follows, and you can review this video to get more details.


    Thanks,
    Lydia Zhang