SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have set up a SharePoint task list that my team is using to track regular deliverables. Based on this, I have created a KPI in PerformancePoint that uses the task list as a data source. I have also defined all of my fields in my data source correctly, in terms of dimensions, time dimensions and measures.

However, when I am creating an Actual or Target measure as part of my KPI, I am finding that I am unable to select all of the members of my task list's Status column. The column is defined with multiple values in a dropdown on the list, but only one value is available for selection in the Select Members screen. I have also checked the list to confirm that there are multiple values in that column, which there are.

Can anyone suggest how I can make PPS pick these values up please?

Thanks, Steve

share|improve this question

There is a hotfix available that corrects this problem I believe. Encountered the same issue (only the first dimension is available in Dashboard Designer).

The hotfix corrected the problem for me.


share|improve this answer

Some time since I have used Dashboard Designer. But if I remember correctly Dashboard Designer will only pick up values that are used when you use a SharePoint-list as a datasource. If you only have tasks in your list with Status Completed, you can only pick Completed from the members screen. It doesn't matter how many choices the column has, only how many of the choices are used.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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