Share via

A community member has associated this post with a similar question:
Pivot Table changes format when sliced

Only moderators can edit this content.

Date format changes when pivot table is sliced

Dom 856 Reputation points
May 2, 2023, 12:21 PM

I have a pivot table with dates on columns and rows. I format the date with a custom format as shown below:

 Picture1

However, as soon as I start to apply different slicers, the date format reverts back to the original. Yes, I have the option selected to preserve cell formatting on update checked. The data is coming from the data model. I've tried to format the date in the power pivot model, but this particular format is not available and you cannot create a custom format (and I can't use a FORMAT function because that turns it into TEXT so I can no longer perform date math operations and the sorting goes awry. Have tried linked tables in the PP model, but the date continues to revert. Suggestions?

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
5,382 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,059 questions
0 comments No comments
{count} votes