BI Tips: Date Sorting

Often, when displaying the Date Hierarchy in your Tablix, you will notice that it will order the dates incorrectly. To correct this, follow the following steps:

  1. Click inside table.
  2. Right-click on the date group (found at the bottom in either the row groups or column groups box -- see above photo).
  3. On the sorting tab, click the fx” button (see below photo).
  4. Change the expression to this: =CInt(Fields!Day.Value)

If you have any questions about this feature or BI in general, please contact your Account Manager directly.