Analytic charts & grids in PerformancePoint Services

Analytic charts & grids are interactive visualizations rendered by PerformancePoint Services for SharePoint 2010. They let users drill down, across, and through any hierarchy in the model: hook it up to an Analysis Services database or PowerPivot model, define the initial layout, and you’re done. There’s nothing more to do to enable this interactivity.

Here’s an analytic chart in a SharePoint dashboard… what happened on the 11th?


The chart shows its true colors when you use the context (right-click) menu; to learn more about the 11th we might right-click then drill into Flight or Destination. We could also use Decomposition Tree or drill down to the tabular source data using “Show Details”.


Analytic charts & grids are always exportable to Excel or PowerPoint for re-modeling or presentation.

What’s new in SharePoint 2010?

Comparing additional measures: In the analytic chart above, we might wonder about different types of delay. The new “Select Measures…” option lets us bring in additional measures from the model to augment or replace the current measure.

Here we’ve added a few specific delay type measures, and are removing the original measure “Arrival Delay”:



Turning on simple inline filters: The new “Value” and “Top 10” filters support simple scenarios such as “show only hospitals in the top 20% in terms of number of unoccupied beds” and “show only homes with gas bills over $500 in December.” These are in addition to “non-empty” and show/hide item filters.



Working with the chart’s bottom axis: Most elements in analytic charts are clickable; the only elements that weren’t clickable in PerformancePoint Server 2007 were those on the bottom axis. Now these labels are clickable too.

Comparing values angularly: Regardless of the dangers of pie charts, now possible to switch to this popular kind of chart. (Keep in mind you can always switch to 100% stacked bar or any of the other chart types.)



The improvements discussed so far are accessible in SharePoint dashboards, but enable dashboard designers too, as you create reports using the dashboard-user features right in Dashboard Designer.

Here are a few additional new things for dashboard designers:

Delivering interactive reports doesn’t require deploying a dashboard or even configuring web parts: Analytic charts & grids, as well as scorecards and strategy maps, are directly accessible from the SharePoint list they’re stored in. On any PerformancePoint Content list view, select a report and choose “View Report.”


You can use SharePoint list views to build the “briefing book” you want your users to see. (For example, you might add a filter to the list view to show only reports with a particular tag.)

Using conditional formatting defined in the model: If you’re using an Analysis Services model that contains rules for cell coloring or fonts, that formatting is honored by analytic grids. This is on by default; you’ll find the checkbox to turn it off under Edit > View > Settings within Dashboard Designer.

Overriding model measure formatting: Though we recommend default formats defined in model, for cases where you can’t touch the model, or you need different format for specific reporting (for example to shorten “2,113,535.35” to “2.1M”, you can now override format per-measure. In the analytic grid, select a cell then select one of the format buttons from the Edit ribbon, or Edit > Format Numbers. In an analytic chart just use the Edit > Format Numbers dialog

Wade Dorrell, Program Manager

Comments (24)

  1. Jesse Orosz says:

    Is there a way to format the axis?

    For example, we have data that is between 800k and 900k, and I would like to set a minimum of 700k on the axis.


  2. Michael says:

    Are you planning to support custom colors / formatting for diagrams? We have a lot of customers needing this feature before implementing PPS?

    Thanks for your feedback!

  3. Jesse Orosz says:


    We've been really wanting to move over to performance point, however it seems that customizing charts has some real limitations.

    Is there anyway to format the axis for example?

  4. Hi Jesse. There isn't a way to set min-value on the axis as of PerformancePoint Services for SharePoint 2010. The min/max values are selected automatically by the system as the user of the dashboard directly interacts with the report (in one case a min of 700k might make sense, but when a user drills down to a lower level, which they can do directly in the charts, a min of 700k might no longer be reasonable.) The charts try to keep things reasonable automatically so the person using the dashboard doesn't have to do it themselves. But yes, we get formatting requests often, more than any other request for analytic charts… and we are keeping it in mind for next.

    For highly formatted charts Excel Services and Reporting Services are currently the much stronger options (but they currently have less direct-surface interactivity.) Both run in SharePoint 2010 & can be used in dashboards.

  5. Niranjna says:

    Can I know if any one hav eidea about triangle  reports using perofrmancepoint

  6. Qazafi says:

    Hi There

    Is there any way we can use Label filters inside analytical grids or chart inside performance point service as we do inside excel 2007/2010 pivot table while using analyses services cube


    Syed Qazafi

  7. Qazafi says:

    Hi There

    Is there any way we can use Label filters inside analytical grids or chart inside performance point service as we do inside excel 2007/2010 pivot table while using analyses services cube


    Syed Qazafi

  8. Sruthi says:

    Can we slice the One Measure into 4  subMeasures and keep all the remaining measures same?

  9. Mahesh says:

    It will clutter the cubes if we have to create every possible calculated member in the cube. It will not be practical to create simple measures like Sales*1.1 or Ratio of two different types of products in the cube.  Is there any way we can create calculated members in the dashboard (presentation layer)? This is the limitation that is stopping us from moving to PPS from ProClarity.

  10. Silva, Thiago says:


    Can I manipulate this charts programmatically? I can not find documentation about it .. :S

  11. Conny says:


    I need to change the color palette of a PerformancePoint Services Analytic Chart. Is this possible somehow?

    Thanks for help.

  12. Kieran says:

    Bar charts?

    Change colour pallete?

  13. Conny says:

    Hi Kieran,

    a PPS Chart has default colors for its value-series. The first three bars are green, red and blue for example. I want to change that colors to my own palette. (green, blue, yellow) How?

    But it seems that nobody can answer these questions because PPS has absolutely no ability for own manipulation…

    Yours desparately… =(  

  14. Tatyana says:

    My client asked me to put more information ito analytic chart report – for example, after drill down ther is no way to see what was the upper level value , for example, driil down Countries -< Cities from USA country to Jerusalem city we cannot see that we came from USA. How this information can be added to the report?

  15. Mark O. says:


    Is it possible to directly drill down (in a bar chart) if i only click the LEFT mouse-button? Or is the "right-button-click" the only possibility to drill down? Mostly there are too many options… 🙁

  16. Tatyana says:

    Mark, if your chart is based on hierarchy, simple click will work as a drill down

  17. Sean says:

    It would be nice if you could remove all dimensions from a chart and start from scratch.   Also, it would be nice for the dimension labels to not be flattened (1 legend item per measure and attribute hierarchy member).    Each column would appear stacked on the x axis  like Q1 on bottom Jan on top.

    I mentioned this to a partner support consultant also.

  18. Bob Italy says:

    We have very long dimension descriptions – is there anyway of being able to display the complete legend text in PerformancePoint Charts – this is more of a problem when we export the charts to Excel or PowerPoint format. Please let me know if there is any work around to do this?

    Thanks for you help.

  19. John says:

    We have very long Dimension Descriptions is there any way to increase the numer of characters in the PerformancePoint report Legend – it is more of a problem when we have to export the report to PowerPoint or Excel format – any workaround to this would be greatly appreciated.

    Thanks for your help

  20. Wade Dorrell says:

    Bob/John, there isn't a way to set the legend width maximum on PerformancePoint Services analytic chart legend. One dashboard-user tip is prior to export, change report type to grid (right-click in the background and choose Report Type->Grid), THEN export to Excel. In Excel you can add the chart and do all things formatting (including customization of the legend) and move on to PowerPoint if desired. The downside of course is additional complexity in 'export', but this unlocks a lot of formatting options on the Excel side while still having PerformancePoint analytic chart exploration capabilities. My other tip is if the exploratory capabilities of the analytic charts aren't critical, you could use Excel Services charts in the dashboard and again have options about legend.

  21. Sai says:

    Can we create a mixed-type charts (combination of line & bar chart) in performancePoint?

  22. Wade Dorrell says:

    Sai, in the PerformancePoint analytic chart it's automatic when using a %-formatted measure and a non-%-formatted measure together in the same chart (specifically, it'll be mixed line-bar with separate vertical axes for the % and non-% measures.) Unfortunately there's no way to configure it manually per series or measure. But for specific formatting purposes we recommend pulling in Excel Services or Reporting Services visualizations, which can be configured this way. Here's how to create a mixed type chart in Excel Services:…/combining-chart-types-adding-a-second-axis.aspx

  23. K. Mohammed Mustafa says:

    Hi Experts, I have a dashboard with 2 zones splitted horizontally. The zone on the left has a scorecard and an SSRS report stacked each other. The zone on the right has an analytic chart. When there is scorecard visible on the left, the chart on the right should be visible. When there is SSRS report is on the left zone, then the chart should be hidden. Please give your thoughts to achieve this. Thanks

  24. Ahsan Misbah says:

    Hi MSFT,

    Is that possible that can i rename the column. If yes then how or any article or links suggestion for me is very valueable and appreciateable.


    M Ahsan