Back

BI Tips: Date Sorting

by Ashia Coleman on Sep. 25, 2015 in Business Intelligence Mobile Industry

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.