4

I need to create some dashboards in SharePoint Online (with OOB or any feature provided by MSFT), I am not allowed to use any kind of Custom Code for it. As Performance Point is not available in SPO, I am stuck.
Any suggestion how would I achieve it!

Note: Data is in SharePoint list.

  • I just come to know about Power-view, is it presented in SharePoint online to create dashboards! – cjs Jul 30 '15 at 11:17
  • 1
    You probably mean Power-BI, which is an additional product from Microsoft and you have to pay for it, it can visualize data from SharePoint but has nothing to do with SharePoint – Danny '365CSI' Engelman Jul 30 '15 at 12:27
  • What kind of data do you want to display in your dashboard? – Louis Jul 31 '15 at 0:39
  • @Danny... I am talking about the MSFT reporting tool Power-View that is part of Power BI. I was thinking to create dashboard in Power-view and then publishing it on SPO. By-the-way I have Power BI license also can I achieve something, I desire, with it ! – cjs Jul 31 '15 at 6:24
  • @Louis... it is the data from Info-Path Form, it contains Text, Integer and alpha numeric. – cjs Jul 31 '15 at 6:26
1

Knowing that your data is in SharePoint Lists, and on dashboard you would want to show some latest items from them. You have options like:

Also it is very important to know When to use the Content Query Web Part or the Content Search Web Part in SharePoint

  • 1
    Asad.. I guess you interpret my question in some sense for VIEWs in SharePoint. I am actually looking for Dashboards (pie charts and Bar Graphs etc.). – cjs Jul 30 '15 at 11:10
0

Although you wrote you cannot use any kind of Custom Code and might already know, if you are allowed to use Javascript, you can display listview as chart.

http://www.sites.se/2013/12/sharepoint-online-charts-office-365/

0

Here's what I've tried to do : Javascript code to show charts, but since you said without custom code, that's not an option, so the other way is Power BI. I've tested it on my tickets list page and it looks fine, it can query Sharepoint lists. However, here are a few negative points : no real time update (or at least I don't know how to do it), so you have to update the file manually by pressing the update data button; I didn't find the way to change titles in the charts (I read that would come in next updates). enter image description here

  • your dashboard is very nice.. can you share your Java script codes. I'll keep it for future use [where customer can allow codes ;) ] – cjs Jul 31 '15 at 6:30
  • Hi @cjs, it's not Javascript, it's an Excel sheet made with Power BI. However, I also managed to do charts with Javascript, which was quite difficult. I'll try to post something in another thread. – Chris23 Jul 31 '15 at 7:54
0

The best possible solution would be using google chart api or other third party chart api's which can be used at client side via content editor web parts.

SharePoint online offer's JSOM based api which you can easily integrated with google chart api for mapping the list as data source.

Personally, I have tried this many times in earlier SharePoint versions and it is very intuitive and handy. The only thing you need to learn is its methods/properties for populating specific charts

Pls refer the below reference links:

Link-1

Link-2

Link-3

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.