ExcelAtEverything
Active Member
- Joined
- Jan 30, 2021
- Messages
- 351
- Office Version
- 2019
- Platform
- Windows
Hi, & thanks for reading.
I've tried everything I know, and every possible fix I could find on the internet, but I cannot get my dates to group in this Power Pivot table. I need to be able to select the MONTH and YEAR grouping, but I can't get to the place where you change it. The pivot table itself is rooted from a Power Query, which is loaded to connection only. The dates, which are all formatted as dates in PQ are also formatted as dates in their respective cells.
When I click into one of the dates, right-click, & then click on "group", nothing happens (& I of course get same result by using Pivot Table Analyze tab to do this). No window pops up, & no change. If I try selecting all dates in the column to try clicking on group, then I get the "Cannot group that selection" popup. I have dozens of other pivots in this workbook in which I have set the groupings with no problem at all, but nothing seems to work here. Any help greatly appreciated.
I've tried everything I know, and every possible fix I could find on the internet, but I cannot get my dates to group in this Power Pivot table. I need to be able to select the MONTH and YEAR grouping, but I can't get to the place where you change it. The pivot table itself is rooted from a Power Query, which is loaded to connection only. The dates, which are all formatted as dates in PQ are also formatted as dates in their respective cells.
When I click into one of the dates, right-click, & then click on "group", nothing happens (& I of course get same result by using Pivot Table Analyze tab to do this). No window pops up, & no change. If I try selecting all dates in the column to try clicking on group, then I get the "Cannot group that selection" popup. I have dozens of other pivots in this workbook in which I have set the groupings with no problem at all, but nothing seems to work here. Any help greatly appreciated.
