Month format

[AmalrajRRD1]

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?

[Anonymous]

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

[rocky09]

Column = FORMAT(Table1[Date],"MM/YYYY")

use this.

[AmalrajRRD1]

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

[rocky09]

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