Report: Sorting is not working in SSRS Report

Sorting can be done in two places.

1. In the DataSets query
2. In the Tablix property

If you have sorting by one column in Datasets query and by another column in Tablix query then Tablix sorting criteria gets priority.