I have the following Performance Point chart:

As you can see, the "age" ranges are completely out of order. I'd like to sort them properly: 0 to 30, 31 to 60, etc. I'm able to accomplish this no problem in Reporting Services by using the sort property of the group. From what I know of PP, that isn't possible within a chart. I could always customize the MDX query, but then you lost the drill down ability in the report - which is what I need.

Is there any way to get the bottom axis to sort the way you would want it to??

Thanks!!

I am trying to figure out how it is currently sorted. I would have expected this to at least be sorted alphabetically by the age range names.  How does this look if you remove the other attribute you have in the series.

Either way, in order to get the age ranges to sort as you want them, you should go into your SSAS or PowerPivot solution and set the Order By property for the attribute and specify the column that is needed to sort these age range names.  Whether that is the Key Column or another attribute in the dimension.  The model is what defines the sort order, otherwise like you mentioned you would need to use custom MDX and then you will lose the interactive capabilities of PPS.

I just have the client and the invoice amount and it still displays in that weird order.

And I checked my model, and I actually already do have the Age Range set up to Order By the Invoice Range ID...

Do you mean Age Range ID?

Is this a tabular or multidimensional model?

If multi, do you have this setup to order by the other attribute, or is the ID column the KeyColumn and you can simply order by Key?

If you query or browse the cube do you get the expected order of the Age Ranges? 

PPS will respect what ever you have defined in the model unless you changed the sort order in the chart and used some other logic.

Yes...Age Range ID. And the Age Range ID is the key column, so I have Invoice Age Range set to order by Key.

If I browse the cube, the Age Ranges are ordered just like the order that appears in PPS:

...and on a separate note. How does one refresh a data source in PPS? I have a couple of data sources that have new tables and updates, but they aren't being reflected.

Thanks!

If the PPS chart is not sorting properly then you would need to review the MDX that is being generated and most likely something was done to the chart already that is causing this not to display as expected.  You could simply create a new chart and simply verify what you are seeing when browsing the cube because that is what you should also see in PPS.

To refresh a data source you can simply Save it and publish it again.  If you have Dashboard Designer already open while you are making changes these will not be available to Analytical Charts.  They will be available to KPIs and Scorecards though.  To see these you will need to close and reopen Dashboard Designer.  There is some caching of items going on that I still have not figured a workaround for since the product was developed and I know your frustration:)

I actually just did recreate the chart and I'm still getting the odd sorting behavior. I'm not sure why even when browsing the cube, the sorting is off even though I'm supposedly sorting on the key - which is sorted in the proper order. If I pull in INV RANGE ID and browse the cube, it sorts just fine on its own. If I only use INV RANGE ID in PPS, it also sorts just fine...

Not sure what's going on here...

Ah, yes, I see that even in browsing the cube your screenshot does not look to be in the proper order at all.

I would review the dimension attribute properties to verify the key and name column references.  If these are set properly and the order by is set then both the browser and PPS will display this properly.

Thank you!!! Something so simple but yet completely missed it!!

Thanks a million!!

Still in the same spot - http://social.technet.microsoft.com/Forums/en-US/home?forum=ppsmonitoringandanalytics

Microsoft just did an overhaul of their forums UX - http://denglishbi.wordpress.com/2013/06/19/microsoft-forums-ux-redesign/