Pivots with 'Show items with no data' checked now associating wrong months with quarters

Copper Contributor

Starting today, 12.12.2022, our data pivots that have 'Show items with no data' checked are now associating Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, and Dec with Qtr1 and so on with Q2 - Q4. This never happened before today. Anyone familiar with a change that happened recently or how to fix?

3 Replies


Do you mean months "Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, and Dec"  are Qtr1 and other months ("so on") in quarters 2, 3,4 ? Or you mean you had no quarters at all before?


If so you may check in Rows of PivotTable if auto-generated quarter field appears and remove.


In general this setting is responsible for automatic dates grouping


@Sergei Baklan 

here's a pivot table with 'show items with no data' checked.


now every month is included with every quarter.


wasn't this way last week....

Yes I know!! I'm trying to Microsoft to admit they made a change that is impacting this. It's fine as long as they give us a way to set a fiscal year and only associate month with those quarters in our fiscal year. We need to be able to show items with no data AND not have every blasted month show aligned with every quarter