SSRS Bar Chart not sorting as expected

blossompark
blossompark used Ask the Experts™
on
Hi,
I have a Bar Chart in SSRS but I cannot get the Y axis items(Name values) to sort alphabetically.
Below is my Bar Chart in Design Mode
sort issueThe Query that creates the Dataset is sorted  by name and returns the sort order as expected.
I have also set the [name] value to sort A-Z in the Category Groups  Properties.

However, when the report runs, the Names are not sorting  as expected.
Any guidance appreciated.
Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
I have just noticed , it is sorting from "Bottom to top", changed the sort order from A-Z to Z-A, now sorting as expected
changed the sort order from A-Z to Z-A for the Category Groups.name, now sorting as expected

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial