SSRS Sorting the PIe Chart data value

Question

I have a pie chart that has a calculate Result value in percentage (%). I need to sort the % value from highest to lowest. I found the CategoryGroups->Sort Expression from Chart Properties, but it is not allowing me to put a sort expression.

Answer 1

When I want to sort my pie charts, I set the Category Group Sort by value to the same expression as the pie chart's Value. This way the biggest sections will appear first and the smallest sections will appear last.

For instance, if I my pie chart is showing Total Sales I will set the Value to SUM(total_sales). Then I open the Category Group and go the Sorting tab and click the FX button to set the sort order to the function. I use the function =Sum(Fields!total_sales.Value).