Forum Discussion
Solved
format the date column in a table defined by calendarauto()
I have a date table that was defined with Date = CALENDARAUOT() and when I use that date in a slicer all is good except I cannot format it. as you can see in the screenshot, the Format is 14/03/2001...
Locale settings do not affect a date slicer that is generated from a calendarauto() function, as it states on the Locale page its for interpretting numbrs, dates, and time in imported text for this file. My solution was to use the Timeline 2.4.0 slicer instead and turn off weeks and days.
Locale settings do not affect a date slicer that is generated from a calendarauto() function, as it states on the Locale page its for interpretting numbrs, dates, and time in imported text for this file. My solution was to use the Timeline 2.4.0 slicer instead and turn off weeks and days.