Forum Discussion

michaelch's avatar
michaelch
New Member
9 years ago
Solved

Using OData Feed with SharePoint

Using the OData feed in PowerBI I have successfully connected a SharePoint 2016 Online document library to PowerBI. I want a graphical report, bar chart or pie chart for this example, to report on a ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi michaelch,

     

    In your scenario, you should be able to use a clustered bar chart, then put doc type column in Axis field, Count of doc type in Value field for the chart like below.:smileyhappy:

    Regards

michaelch's avatar
michaelch
New Member
9 years ago

Maybe a bar chart is the wrong graphical representation. In SharePoint Online 2016 I have created a costum column in a document library to track document types. What I would like to do in Power BI is to show graphically how many of a certain docuemnt type I have.

 

12 of doc type 1

3 of doc type 4

8 of doc type 5

2 of doc 6

etc.

 

I was hoping that Power BI could just sum up the total count of a particular doc type and then display this in a bar chart. The doc type would be the axis on the bar chart. 

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi michaelch,

 

In your scenario, you should be able to use a clustered bar chart, then put doc type column in Axis field, Count of doc type in Value field for the chart like below.:smileyhappy:

Regards