Forum Discussion

AmalrajRRD1's avatar
AmalrajRRD1
Helper 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
Solution Sage
8 years ago
Column = FORMAT(Table1[Date],"MM/YYYY")

use this.

 

 

 

  • AmalrajRRD1's avatar
    AmalrajRRD1
    Helper 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
      Solution Sage
      8 years ago

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