Forum Discussion
Using OData Feed with SharePoint
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
Hi michaelch,
Based on my understanding, if you have successfully loaded the custom column "document type" to your data mode in Power BI, then you should be able to show it on the report.
However, when I select the field I want to report on in PowerBI and then select the bar chart graph icon nothing happens. No bar chart displays with my document type data.
How do you want show the data of "document type" column for the bar chart, as the Axis, or Value? If you want it shown as the Axis for the bar chart, you still need to specify a column for the Value field of the bar chart, or the bar chart won't display anything.:smileyhappy:
Regards
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.
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