Forum Discussion

WouterAalders's avatar
WouterAalders
New Member
4 years ago
Solved

Change date format on slicer

Hello everyone, At the moment i have slicers like this, but i would like to change the format so that it shows YY instead of YYYY. so that it would show 15 16 17 18 19 20 21. Is this possible and ...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi WouterAalders ,

     

    Based on my test, we can not format a four-digit integer to a two-digit number. So you have to add a new column in your code, like this.

     

    Calendar = 
ADDCOLUMNS(
    CALENDAR(DATE(2019,1,1),TODAY()),
    "Year", YEAR([Date]),
    "YearFromat", FORMAT([Date], "yy")
)


    Best Regards,
    Winniz

v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi WouterAalders ,

 

Based on my test, we can not format a four-digit integer to a two-digit number. So you have to add a new column in your code, like this.

 

Calendar = 
ADDCOLUMNS(
    CALENDAR(DATE(2019,1,1),TODAY()),
    "Year", YEAR([Date]),
    "YearFromat", FORMAT([Date], "yy")
)


Best Regards,
Winniz