Power Pivot automatic grouping of dates in Microsoft office professional plus 2019

%3CLINGO-SUB%20id%3D%22lingo-sub-1531436%22%20slang%3D%22en-US%22%3EPower%20Pivot%20automatic%20grouping%20of%20dates%20in%20Microsoft%20office%20professional%20plus%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1531436%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20the%20future%20of%20automatic%20grouping%20of%20dates%20in%20power%20pivot%20still%20exist%3F%3C%2FP%3E%3CP%3EWhen%20I%20try%20to%20create%20a%20pivot%20table%20from%20a%20data%20model%2C%20which%20includes%20a%20date%20column%2C%20it%20does%20not%20create%20date%20groups%20(e.g.%20month%2C%20year%20etc.)%20automatically%20anymore.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot%20for%20your%20help%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EC%C3%A9dric%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1531436%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1531493%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20automatic%20grouping%20of%20dates%20in%20Microsoft%20office%20professional%20plus%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1531493%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F732884%22%20target%3D%22_blank%22%3E%40cedi4ever%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMake%20sure%20that%20grouping%20dates%20feature%20is%20not%20turned%20off%20in%20Excel%20Options.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20refer%20to%20the%20attached%20screenshot%20and%20see%20if%20that%20helps.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Date%20grouping.jpg%22%20style%3D%22width%3A%20824px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F206261i6B40BC36C37130EA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Date%20grouping.jpg%22%20alt%3D%22Date%20grouping.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1531590%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20automatic%20grouping%20of%20dates%20in%20Microsoft%20office%20professional%20plus%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1531590%22%20slang%3D%22en-US%22%3EIt%20is%20not%20checked%20...%3CBR%20%2F%3EThe%20grouping%20works%20in%20normal%20pivot%20but%20it%20does%20not%20work%20in%20power%20pivot.%20Until%20the%20Excel%202016%20update%20it%20did%20not%20work%2C%20so%20I%20assume%20that%20Microsoft%20disabled%20it%20once%20again%20in%20Microsoft%202019.%3CBR%20%2F%3EAny%20further%20replies%20are%20highly%20appreciated!%3C%2FLINGO-BODY%3E
New Contributor

Does the future of automatic grouping of dates in power pivot still exist?

When I try to create a pivot table from a data model, which includes a date column, it does not create date groups (e.g. month, year etc.) automatically anymore. 

 

Thanks a lot for your help in advance.

 

Best,

 

Cédric

2 Replies

@cedi4ever 

Make sure that grouping dates feature is not turned off in Excel Options.

 

Please refer to the attached screenshot and see if that helps.

Date grouping.jpg

It is not checked ...
The grouping works in normal pivot but it does not work in power pivot. Until the Excel 2016 update it did not work, so I assume that Microsoft disabled it once again in Microsoft 2019.
Any further replies are highly appreciated!