Sorting a chart in SSRS sounds easy enough, but the sort option isn’t where you might expect to find it. In this example I am using Visual Studio 2012.
First let’s take a look at an unsorted chart. Even if you sort values in your underlying dataset, your chart will likely not be sorted.
One might expect to find sort options by right clicking the chart and going to Chart Properties which will not work. You then might think, of course it must be on the Series Properties. However, that again will not work. So let’s take a look at how to sort the chart. Start by double clicking the chart which will bring up the Chart Data box. Now you will probably expect to find sort options by looking at Value options.. and you would be wrong yet again. Click on the drop down arrow under the Category Groups. Select Category Group Properties.
Here you will find a Sorting option. Click Add and select what you would like to sort on.
Now you can see that we finally have a sorted chart.