I have an issue with dateformat and sorting months in a pivottable.



I have created a sample file with two pivot tables in it (sorry its in Dutch).
- one WITHOUT adding to the data model => shows the months in the correct format (JAN FEB etc) and correct sequence
- one WITH addition to the data model => does not show the months as a three-letter abbreviation, but as a date format with the first of the month as the day (1-2-2017, 1-3-2017, etc.)
The data table is filled with data that directly from an ERP system.

What I can not figure out is how to get the date format right when I add the pivot table to the data model.
I need that because there are multiple pivot tables in the original spreadsheet based on multiple data tables. These are all linked (relationship) to organizational unit.
With that, I can adjust all the graphs at once to the selected team with one slicer.

I'm curious if anyone has an answer to this.

I work with Office 2013, without power BI and without power query.

Attached Files

Datatable Verzuim + 2 pivottables - 1 with and 1 without adding to datamodel.xlsm (430.5 KB, 11 views)