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

New 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

@JWood145 

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.

image.png

In general this setting is responsible for automatic dates grouping

image.png

@Sergei Baklan 

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

deeger_0-1670980026562.png

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