Hi

I have created a dashboard using the SharePoint list. I am using this dashboard to create a scorecard and the fields I want to use are not displaying in the drop down list. How can I make all the filed show in the drop down list of the scorecard creation wizard

The aim is to create a dashboard that will report on the selected fields from this list I used as a data source.

Please help urg

Hi Nozipho,

According to your post you want to create a dashboard with dropdown to show the report based on the dropdown selected value. 

To accomplish this, you may have to pull the data from SharePoint list to excel and use the excel service to show the report. Please follow the below link which should help you more. 

Show the dashboard report based on dropdown value

If you want more help, please let u

Hi Sek

Thank you so much for your response it is so relevant to what I am trying to achieve but can you send me the link on excel 2010? They are struggling to follow this excel 2013 link.

Thanks

Hi,

Please try the below links. 

https://blog.netnerds.net/2012/03/sharepoint-2010-creating-dashboards-and-charts-for-sharepoint-lists-using-performancepoint-and-excel-services/

http://blogs.technet.com/b/officebuzz/archive/2010/03/05/creating-a-basic-report-in-excel-2010-using-slicers-and-publish-it-to-sharepoint.aspx