Forum Discussion
Sorting column chart in Report Builder not working
I have a simple column chart I built in report builder, and need to change the sort order of the x axis, but nothing will make the change "stick". The chart shows sales by currency, with sales on the...
You will need to sort the row groups, if you have more than one then you will need to sort all of them based on the category you like:
You will click on each group then select group properties and add the sort field or change it, you will find that the reason why sorting from tablix is not working is because the higher group in row groups hierarchy is sorted on a different group which override your sorting, this happen when you work on a copied list or chart that sorted differently, hope that will help.