Integrating Trend Charts in Dashboards

After you have created your trend charts (see the trend chart creation blog here), you can use them in a dashboard.  The trend chart needs to be connected to the scorecard which it is based on in the dashboard designer, linked via the KPI ID to the Row Header in the Trend Chart as follows:

1.     Add the scorecard into a zone in your dashboard.

2.     Add the trend chart into a zone in your dashboard.

3.     In the Available Fields list in the scorecard, drag the KPI ID field and drop it into the input area for the trend chart.

4.     Map the Dashboard item endpoint as RowHeader and leave the Source value as KPI Row: KPI Id.



5.     Publish your dashboard.  Upon selecting each KPI in the scorecard within Sharepoint, the appropriate trend chart for that KPI will be displayed.



Alyson Powell Erwin (

Comments (4)

  1. Suman_sundar7 says:

    How can i give the option of selecting the no. of forecast period after publishing in sharepoint.

  2. beeeyedev says:

    How can i pass parameter from scorecard to the trend charts?

  3. guru451 says:

    How can I change the scale to start at a number higher than zero?

  4. MSDN Archive says:

    I know of no way to set the number of forecast periods in sharepoint, we allow for that setting in the dashboard designer.

    Dashboard filters should pass into the trend chart assuming the dashboard filter uses the same hierarchy and source as the trend chart is based off of. Link to the page filter. I just confirmed that this works in the correct setting.

    I know of no way to change the scale – sorry.

Skip to main content