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

4 Replies

  • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI AmalrajRRD1,

     

    Nope, if you choose between mode, it will show MM/DD/YYYY format, current there is no feature to format display style in slicer.

    Maybe you can submit an idea for this requirement.

     

    Regards,

    Xiaoxin Sheng