Forum Discussion
date format in slicer
Hi urpalani,
The date format display in the slicer visual decided by the local client Regional settings. Please make sure your region setting like below:
Best Regards,
Qiuyun Yu
If you have somehow changed the date format within the slicer itself, and regardless of the date format you change the source data to, it will still not update. It's likely because you have accidentally or unintentionally grouped the dates somehow. This happens automatically in many cases when placing the date field in other pivot sections.
To revert to the original date format, drag the Date field back into the rows, then right-click and select Ungroup. Now your date should be back in its original format. Now you can insert the slicer, and the date will be in your correct (original) format.