Forum Discussion

AmalrajRRD1's avatar
AmalrajRRD1
Icon for Helper II rankHelper II
8 years ago

Month format

Hi all,   please find below image     whenever i am creating month in filter . it's showing M/DD/YYYY format.   is there possible to show MM/YYYY format in slicer filter?
Interesting Links
Tutorial Requests
rocky09's avatar
rocky09
Icon for Solution Sage rankSolution Sage
8 years ago
Column = FORMAT(Table1[Date],"MM/YYYY")

use this.

 

 

 

AmalrajRRD1's avatar
AmalrajRRD1
Icon for Helper II rankHelper II
8 years ago

i was tried this . in chart view i am getting correctly but slicer options in showing MM/DD/YYY format.

  • rocky09's avatar
    rocky09
    Icon for Solution Sage rankSolution Sage
    8 years ago

    I am sorry, I misread your post. I am not sure how to do that.