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:
- Click inside table.
- Right-click on the date group (found at the bottom in either the row groups or column groups box -- see above photo).
- On the sorting tab, click the “fx” button (see below photo).
- 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.