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 941 Reputation points
2023-05-02T12:21:19.4166667+00:00

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 and Office Install, redeem, activate For business Windows
Microsoft 365 and Office Excel For business Windows
0 comments No comments
{count} votes